Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
14 - Magnetar

 Hi  @willd9 

 

One way of doing this

 

ShankerV_0-1674211636124.png

 

Many thanks

Shanker V

 

BS_THE_ANALYST
11 - Bolide

One way you can do it! @willd9 

I've attached the workflow :)

 

BS_THE_ANALYST_0-1674211745166.png

 

Felipe_Ribeir0
15 - Aurora

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