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

Concatenate two headers in file

Devika
8 - Asteroid

Hello,

 

Please help to add /Concatenate the two headers that are in the file .Have attached the input and wanted output.

 

 

8 REPLIES 8
binuacs
21 - Polaris

@Devika you need to extract the headings and combine using the summarise tool then union with the original file

 

binuacs_0-1650972509276.png

 

Devika
8 - Asteroid

Hello Binu, @binuacs 

 

Would request you to help me with the changes that i have to make if i take out the *INPUT* Row 

Devika_0-1651054901696.png

 

Devika
8 - Asteroid

This is the input file for which i would like to apply @binuacs 

binuacs
21 - Polaris

@Devika in the input tool check the option 6 - first row contains data, once that’s is fine run the workflow you will see the heading INPUT In the first row and you can use the sample tool to skip the record 

binuacs
21 - Polaris

@Devika your latest input file is slightly different from the one you provided initially. I will update the workflow based on the new input file and will post here 

Devika
8 - Asteroid

apologies but i tired but still not getting the exact results like you did @binuacs 

Devika_0-1651059431236.png

 

 

binuacs
21 - Polaris

@Devika attachinh the updated workflow

 

binuacs_0-1651094289922.png

 

Devika
8 - Asteroid

Thank you Binu this works perfect for me now .

Labels