Combine separate bundles from an iterator into a single bundle.

[Donna_Boj]

Hello, Hoping someone can assist.

I need to compile field-level data from multiple tasks and add it to a CSV file. The issue I’m facing is that the data is arriving in separate bundles, whereas I need it in a single bundle to correctly position the fields in the CSV, ensuring they appear in the right order and row.

Does anyone know of a way to merge separate bundles into a single, easily manageable data set?

Any suggestions would be very welcome!

[_Manish_Singh]

Hello @Donna_Boj, You can use the array aggregator. For example, to group the tasks by project, enable the 'advanced settings' and map the 'project' field in the 'group by'.

Something like this..

[Donna_Boj · Accepted solution]

I have managed to solve my issue a different way, that works:

I iterated on an admin only field to ensure the custom form text comes through in the order I want to avoid the bundles going out of order.
Then I format the text in the columns I need then Aggregate on that text again to add the column headers.
This has given me the result I needed for my CSV.

[Sven-iX]

Hi @Donna_Boj 
glad you worked it out - so this is just FYI, with an eye to maintainability/best practice: 

Create a data structure and use the "advanced" module

In the module you'd set the value of a field explicitly, e.g.

Your scenario would then look like 

[Donna_Boj]

Hi Sven, we tried this approach first but we have separate bundles of data that we need on specific rows of the CSV file. We couldn't get the CSV module to create the file this way, unless you know a way to do this?

Many thanks,

[Sven-iX]

specific ROWS? 
hm, can you sort the bundles prior to collecting them in a CSV so they're in the right order?