Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

willd9
7 - Meteor

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 In
James John34UK1
Harry Peterson26US1
Nathan 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?

3 REPLIES 3
ShankerV
17 - Castor

 Hi  @willd9 

 

One way of doing this

 

ShankerV_0-1674211636124.png

 

Many thanks

Shanker V

 

BS_THE_ANALYST
14 - Magnetar

One way you can do it! @willd9 

I've attached the workflow :)

 

BS_THE_ANALYST_0-1674211745166.png

 

Felipe_Ribeir0
16 - Nebula

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:

Felipe_Ribeir0_0-1674212505078.png

 

Labels