Similar to SAS TRANSPOSE

[cetricelaens]

How I can get output similar SAS Transpose proc in Alteryx?

Below in my input 

ID     PLAN    VALUE

100   5300     VALUE1

100   6440     VALUE2

And I need to get a output like below 

ID   VALUE_5300 VALUE_6440

100 VALUE1         VALUE2

[marcusblackhill]

Hey @cetricelaens !

You can do it with crosstab tool. Look if the attached example works to you.

Hope that help!

[cetricelaens]

Sorry , I missed to add another column because I want to transpose it for multiple columns. I have attached Input file and my expected output file

[danilang · Accepted solution]

Hi @cetricelaens 

To get close to what you want, add a transpose tool using the key columns that you need in the concatenated output fields and then use a formula tool to build the new column names.  After the crosstab, the results look like this

I said "close" to your expected result because your expected results has the Plan field in it with the 5300 value.  Is this just a field that you forgot to remove?  If not, how did you determine which of the 2 Plan values to keep.

Dan

[cetricelaens]

Wow. Thanks 🙂 You're right We need to exclude plan