Hi,
is it possible ot replace empty cells with dashes (-) in a csv file generated from an Action Flow which is based on Celonis Data? I found a template for Action Flows to generate and csv File with a appropriate format (see below). Unfortunately my data from celonis contains empty values, which bothers me in the csv since they appear empty. I would like to replace them with dashes(-).
Thank you for your help and best regards,
Jurgen
Hi Jurgen,
you can choose one of at least a two solutions to your problem:
1) Adjust PQL formula in query data module: CASE WHEN TABLE.FIELD IS NULL THEN '-' ELSE TABLE.FIELD END
2) You can use Action flow functions available when clicking in module fields like in Create CSV file:
For example In one of the action flow I'm generating HTML code for email sending - and based on value I'm adding or not HTML color/boldness tags. I would try to use ifempty or if='' syntax.
Best Regards,
Mateusz Dudek
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
