Alteryx Designer Discussions

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

Concatenate rows and create headers

analysiswithtech
5 - Atom

 

2019

2019201920192019201920192019201920192019

2019

 JanFebMarAprMayJunJulAugSepOctNovDec
 ActualActualActualActualActualActualActualActualActualActualActual

Forecast

Sales

100100100100100100100100100100100

100

Cost-50-50-50-50-50-50-50-50-50-50-50

-50

 

I have a data set that looks like the above.

 

I want to create header names that concatenate the three first rows and then unpivot the data, to get something like this:

 

2019-Jan-ActualSales100
2019-Jan-ActualCost-50
2019-Feb-ActualSales100
2019-Feb-ActualCost-50
2019-Mar-ActualSales100
2019-Mar-ActualCost

-50

 

If you could help that would be great. Thanks

2 REPLIES 2
fmvizcaino
16 - Nebula
16 - Nebula

Hi @analysiswithtech ,

 

Take a look at the attached example. I'm using group by to concatenate the rows based in recordID number and transposing as you need. The only thing left to do is to order your data properly.

 

Let me know if that works for you.

Best,

Fernando Vizcaino

AndyMoncla
10 - Fireball

Nice use of the Summarize and Dynamic Rename tools.  Good work!

Labels