Skip to main content

I am trying to combine multiple KPIs into a CSV, but it doesn't seem to work.

Each KPI has different filter so I'm using several Celonis modules to separately get those KPIs. Please refer to the screenshot below.

 

I had the following two problems:

(1) The third Celonis module appears to be running repeatedly many times. So I had to stop the Action Flow manually.

(2) The CSV file also has a very large number of rows than expected. Multiple rows of the same Company appear. Originally, one company with one row is expected.

 

スクリーンショット 2022-08-17 153553 

Is there any method to combine multiple KPIs with different filters into a CSV?

Should I use Iterator/Aggregator to combine those modules?

 

Yours,

Chen

Dear Chen,
Thank you for reaching out.

Yes You are correct, please use Iterator and Aggregator and use the Merge function (at last in the iterator) to club data from all 3 query data modules and feed to the CSV.

Sample Screenshot:

imageimageLet me know in case of any further questions.


Reply