Skip to main content

Hi,

I'm building an AF that sends via email some pdf report and some csv from an analysis.

The thing is that I need to set different filters for the same pdf report or the same table exported in csv.

 

At the moment I have as many modules as are the objects that I need, for example, 4 Create PDF Report modules that print the page with different filters, generating 4 different PDF objects; same for the csv file, I query the data 4 times and generate 4 different csv files for the same table, but with different filters. The AF is working fine, but it's extremely long and it generates A LOT of objects that I need to send via email.

 

I'd like to make it smarter by, if possible, aggregating the PDF sheets into one single file, as well as the csv tables into one file, creating multiple sheets in the csv.

 

Best case scenario would be one PDF file generated by one module in the AF and one csv file, generated by one query data and one create CSV module.

 

Thanks!

Hello,

 

One of the solutions available is to having filter values stored in a temporary tabletable, schedule transformations f.e. 4x in a hour to change values in that table and triggering same action flow with one of the filters of the "query celonis" module taking values from that. You can also trigger that by python, however schedule these to specific hours should be less challenging.

 

Best Regards,

Mateusz Dudek


Reply