Question

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

  • 10 December 2021
  • 1 reply
  • 8 views

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?


1 reply

Userlevel 3
Badge +17

@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