Hello, I have a structured JSON output I am using an iterator to build a CSV from. It’s an inventory from a precious metals wholesaler. The output is fine EXCEPT there is an array of Categories inside the array of items (the number of collections in which may vary) and I want to capture all those ca…

A. If the keys and CSV data structure are equal, it could be just as simple as toggling the “Map” function on the Categories field, and mapping the entire Categories variable into it. B. Otherwise you have to iterate the Categories variable, and aggregate into the “Target structure type” of the “Ca…

The first iterator is iterating the array of items to process each item. You need a second pair of iterator and aggregator just to process each item’s categories. [Screenshot_2024-01-31_150149]

I guess this one will stay above my head. No matter what I seem to do, categories never get filled in the resulting CSV. Thanks for your efforts! [image]

How to create CSV from Iterator where bundles have arrays

Questions

Allen_Vance January 31, 2024, 4:39am 4

I don’t quite follow; when I put in the aggregator, I basically lose the values from the iterator in the CSV, and I only want to aggregate that one variable.

Topic		Replies	Views
Converting an array of arrays to csv where each nested array is a csv row Questions aggregators , iterator , json , csv , bundles	2	251	April 23, 2025
Collection Array Bundle Questions iterator , arrays , csv	2	141	September 18, 2024
Creating a CSV from an HTTP request Questions arrays , http , csv	3	103	April 24, 2025
Help with nested arrays Questions arrays , collections	4	66	June 4, 2025
Mapping bundles from iterator Questions arrays , collections	8	1141	March 7, 2024

How to create CSV from Iterator where bundles have arrays

Related topics