I have a table that I want to have a header at the top of and then be outputted as a CSV. Here is an example of the table I want to see: Parameters:TimeZone=Europe/London NameAgeLocationOpted InJames John34UK1Harry Peterson26US1Nathan Allan19UK0 So I have the rest of the table ready, I just can't think of a way to include the single row/column in the first row/column to act as the title. Any ideas?

Inserting a single row/column at the top of a table

I have a table that I want to have a header at the top of and then be outputted as a CSV. Here is an example of the table I want to see:

Parameters:TimeZone=Europe/London
Name	Age	Location	Opted In
James John	34	UK	1
Harry Peterson	26	US	1
Nathan Allan	19	UK	0

So I have the rest of the table ready, I just can't think of a way to include the single row/column in the first row/column to act as the title. Any ideas?

Output

Accepted answers

BS_THE_ANALYST

One way you can do it! @willd9

I've attached the workflow

help1200123yxmd.yxmd

All comments

ShankerV

Hi @willd9

One way of doing this

Many thanks

Shanker V

Inserting a single rowcolumn at the top of a table.yxmd

BS_THE_ANALYST

One way you can do it! @willd9

I've attached the workflow

help1200123yxmd.yxmd

Felipe_Ribeir0

Hi @willd9

To create this output correctly, its necessary to save the output file as a flat file (the csv output option cant handle the fact that your first row does not have the same columns that the table has). Check the attached workflow.

OUTPUT:

Inserting a single rowcolumn at the top of a table.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703