Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
14 - Magnetar

One way you can do it! @willd9 

I've attached the workflow :)

 

BS_THE_ANALYST_0-1674211745166.png

 

All the best,
BS

LinkedIN

Bulien
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