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
  • 83 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+20
  • Safer
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings