Question

json arrays/list related by index to excel file

  • 30 November 2017
  • 1 reply
  • 2 views

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

Badge +22

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