Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Concatenate two headers in file

Devika
Asteroid

Hello,

 

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

 

 

8 ANTWORTEN 8
binuacs
Arcturus

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

 

binuacs_0-1650972509276.png

 

Devika
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
Asteroid

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

binuacs
Arcturus

@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
Arcturus

@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
Asteroid

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

Devika_0-1651059431236.png

 

 

binuacs
Arcturus

@Devika attachinh the updated workflow

 

binuacs_0-1651094289922.png

 

Devika
Asteroid

Thank you Binu this works perfect for me now .

Beschriftungen