Skip to main content
Question

json arrays/list related by index to excel file

  • November 30, 2017
  • 1 reply
  • 11 views
J

I have a json file with 3 lists. Zip Code, Occupation Code and Number of Jobs. The index of each array is related to the two other lists by index. I've posted a screen grab. How do I write these to excel such that the columns are ZIP, Occupation Code and Number of Jobs? I have tried hours of experimenting. Thanks in advance for help.

1 reply

jdh
Contributor
Forum|alt.badge.img+28
  • jdhContributor
  • Contributor
  • November 30, 2017

There is probably a better answer involving jquery, but you could doubly fragment the json and then recombine the resultant features using the second (rows) json index.

jsonpivot.fmw

Reply


Helpful Members This Week

Community Stats

31,099
Posts
117,907
Replies
38,854
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.