Answered

Remove Header row from a CSV table

(1) Share

Report

Posted on by Nithin_Vanam

Hello,

I am using the Create CSV Table action to generate a CSV from an array. However in the Create CSV Table action, the option to include headers is no longer avaialble and no matter i chose the Automatic or Custom option, the header row is always included.

I have tried to remove the header row using the replace function but that results in a blank line. Could someone suggest how do i get rid of the header row in the CSV Table?

Here is the Create CSV Table action:

Create CSV Table - 1.JPG

Here is the output:

Create CSV Table - 2.JPG

The first row is the Header row. Thanks in advance.

All responses (2)

Answers (1)

Nithin_Vanam 95 on at

Like (1)

Report

Re: Remove Header row from a CSV table

Hi @yashag2255 ,

That did the trick. Thank you so much. I tried with something like body()? but could never get it to work.
Verified answer

yashag2255 24,442 Super User 2024 Season 1 on at

Like (5)

Report
Re: Remove Header row from a CSV table

Hey @Nithin_Vanam

You can refer to the screenshot below to acheive this:

The expression used for the value is:

item()?['Name']
Here, Name is the key from the object in the array. Similarly, for the next one, it will be age in the place for name. You can replicate accordingly for the data that you have.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!