Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Best way to bulk process Excel to JSON for each column in a spreadsheet, where each JSON document must contain a common ID column and a unique column

I am in the process of converting a large Excel file to separate JSON documents for each column in the Excel, keeping a common ID column that each JSON document must contain. The hard way of doing things is using an AttributeKeeper to preserve the common ID column that I need and the specific column that I want to make a JSON document for, with a separate writer for each JSON document. Is there an easier way to do this, similar to a Fanout but instead of grouping by rows of similar feature types I can do it by column?

@sclevenger​ 

You could probably modify the second or third method (AttributeExploder, no Aggregator) in this Transpose a Table article to create features for each column in Excel.

Then it should be possible to use a fanout based on the attr_name attribute, which would be the column name.

Reply


Community Stats

30,176
Posts
114,538
Replies
37,835
Members
Terms & ConditionsCookie 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.