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
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
Hey @cetricelaens !
You can do it with crosstab tool. Look if the attached example works to you.
Hope that help!
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
