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

Question

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

Transpose_multiple.yxmd

RolandSchubert · Accepted Answer

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 Answer

Hi @Elyannicko1

My take

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

Hope this helps : )