Transpose defined columns (more than "Value" and "Name")

[Elyannicko1]

Hi everybody!

had been confronted by a multiple transpose case, where I cannot find any possible solution from the basic Alteryx toolkit to find a relatively straightforward solution on this topic.

What I actually want is that, next to "Value" and "Name" columns, there are two other columns that need to stick to the relevant "Value" and "Name". I added in both text inputs the input data stream (just a structure) and the target format (similar to the "Transpose"-Tool).

Would appreciate if anybody has a solution for this topic.

Please find the "workflow" example.

Best

Elyannicko

[RolandSchubert · Accepted solution]

Hi @Elyannicko1 ,

I think, the Arrange tool could be helpful.

Add the value columns as a new column with a descriptor from filed names and add "S" and "H" columns. If there are additional months, you have to the them in addition to "Jan" and "Feb".

Let me know if it works for you.

Best,

Roland

[atcodedog05 · Accepted solution]

Hi @Elyannicko1 

My take

But definitely, @RolandSchubert method of make group tool is the best.

Hope this helps : )

[Elyannicko1]

Wow thanks a lot guys, helped me both a lot in my day-to-day work!

[atcodedog05]

Happy to help : ) @Elyannicko1 

Cheers and have a nice day!