community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

how to concatenate multiple headers

Hi,

 

I am new to alteryx and trying to concatenate two headers to get one desired value. Kindly request someone help. Sample attached.

 

Regards,

Satish 

Nebula

Hi Satish

 

This work flow(attached) will transpose your data

Solution.png

 

Note that I removed the output from your excel file to use as the input for the workflow.  The new input file is called Sample_Input.xlsx and the workflow is expecting the input file to be in the same directory as the workflow.

 

Dan

 

 

 

Hello Daniel,

 

Thank you for your reply, however i am trying to concatenate values from two different header row, example Regular and 01 are in two different rows, i have a need to concatenate two headers to one header and then do the transponse. How i am making sense. 

 

Regards,

Satish

Nebula

Are you saying that the input file is actually

 

Employee IDREGULAROVERTIMEVacation
Pay Code123
12345100400700
23456200500800
981011300600900

 

instead of 

 

Employee IDREGULAROVERTIMEVacation
Pay Code010203
 01 REGULAR02 OVERTIME03 Vacation
12345100400700
23456200500800
981011300600900

 

And the bold line needs to be created?

 

If this is the case, you can use the attached workflow.  It builds the header row before transposing the data

 

Solution v2.png 

 

Dan

Hi Dan your understanding is correct

 

Regards,

Satish

Highlighted
Nebula

See my previous updated post

 

Dan

Labels