Skip to main content
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

  • December 10, 2021
  • 1 reply
  • 90 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

debbiatsafe
Safer
Forum|alt.badge.img+21
  • Safer
  • 648 replies
  • December 16, 2021

@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.