Skip to main content
Question

json arrays/list related by index to excel file

  • November 30, 2017
  • 1 reply
  • 12 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

jdh
Contributor
Forum|alt.badge.img+37
  • jdhContributor
  • Contributor
  • 2002 replies
  • 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

Community Stats

32,087
Posts
121,869
Replies
39,731
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.