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

Alteryx Designer Desktop Discussions

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

How do I change the default headers to Field X?

Carluccio555
9 - Comet

I have data which has a few rows of headers. The first row of headers is 'USD' and as you can see from the screen attached, Alteryx is renaming these as USD1,2,3 etc

 

How can I get the headers to continue as F5,F6,F7 etc and for the USD header to become a data row (so I can deal with it separately).

 

Carluccio555_0-1668735193458.png

 

Thanks

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @Carluccio555 

 

You could select the option First Row Contains Data on the input tool config

Felipe_Ribeir0_0-1668735924385.png

 

KrishnaChithrathil
11 - Bolide

@Carluccio555 

I donno whether I understood it in the right sense. Is this the way you want your output to look like?

KrishnaChithrathil_0-1668746430285.png

 

KrishnaChithrathil
11 - Bolide

@Carluccio555 

I did something like this with my understanding. 😄  But I seriously expect a better workaround for this.

*If this is not what you expect, please provide us a sample output.

KrishnaChithrathil_1-1668748453252.png

KrishnaChithrathil_0-1668748418052.png

 

Carluccio555
9 - Comet

Thanks everyone!

Labels
Top Solution Authors