Handling Dynamic headers while composing a csv file

[Bhagya_pola]

Hello all,

Currently I have a crazy requirement where the headers of a csv file are dynamic, I noticed just now that I can't access any pills in formula mode in order to write a lookup formula for headers section in compose csv action.

Currently the only way I can think of is handling it with if and else conditions based on a field from input and compose csv accordingly.

Is there any other efficient way we can achieve this?

Thanks in advance.

[shivakumara · Accepted solution]

Hi @Bhagya_pola ,

My perspective on this requirement is as follows:
Assuming contents (headers to be formed) are coming from application or from file.

1. Extract the dynamic keys (headers) by writing a script in Python, Ruby, or JavaScript.
2. Since the ‘Compose CSV’ step requires the headers to be aligned with a newline (\n), we can generate that using a formula.

Using multiple IF/ELSE conditions would make the design overly complex and reduce readability.”

Try this approach and let us know if you need further help.

Thanks and Regards,
Shivakumara K A

[gary1]

Question: are you reading from a CSV or writing a CSV? I can't tell from your description. Can you provide more details?

[Bhagya_pola]

While writing

[gary1]

I'd like to help but I still don't understand the problem.

[Bhagya_pola]

Hello @gary1,

The requirement is to generate a CSV where the headers are dynamic.
Based on a field from the source, the CSV headers need to change.

I configured these headers using a lookup table mapped to the source field. However, I later realized that these formulas do not work in the CSV compose block.

Currently, I am generating the CSV using multiple if-else conditions. I wanted to check if there is a better or more efficient approach to handle this.