Hello,
I’m using Celonis EMS Action Flows which also uses some version of make, but basics should be the same because it’s more about bundle data handling. I want to generate CSV file with aggregated data from Celonis “query data” module, which produces output same as this test one (in parse json).
Unfortunately using numeric aggregation like here: SUM all the numbers from few collections within 1 bundle - How To - Make Community would work if only one column would need to be summed up (I need to sum-up 11 columns), I also want to have all company codes (0001 and 0002 - but it can be 50x of them or more, so it has to be dynamic), so I cannot for example set multiple variables - that will work for aggregation (sum(arrayname{})), but creates additional problem as separate company codes are going into separate operation, which makes creating single CSV much harder.
I’ve attached JSON of blueprint, that can recreate problem.
Simulated output from mentioned Celonis quary data module in JSON.
Visualization of failed aggregation in “Create CSV” module
Desired output is to have csv with two rows and headers:
Best Regards,
Mateusz Dudek