I’m trying to accomplish what I believe should be a straightforward task: generating a single CSV file from data spread across multiple bundles. However, I’m having trouble concatenating the information from these bundles into one cohesive CSV file.
I’ve experimented with various methods, including setting multiple variables, using the text aggregator, and the CSV creator module. While each of these methods works for creating a CSV file from a single line of data (resulting in one CSV per bundle), I need to consolidate all the data from “N” bundles into a single CSV file.
Could anyone provide guidance on how to achieve this? Any help would be greatly appreciated!
Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
There are other types of aggregator modules, click the below links to find out more:
I was using a set multiple variable module after the iterator that generates 5 bundles, this was just to organize the data coming from other iterator but if I put the text aggregator after that the bundles are not aggregated. Now it’s generating 2 bundles because of the first iterator, this is the scenario:
The first HTTP module is getting new Purchase Requests IDs and the second is getting the product list for each Purchase Request. Right now the text aggregator is doing the following:
