Hi all,
From this table :
Id Var
1 A
1 B
2 C
2 A
2 Y
3 Z
I'd like to obtain :
Id A B C Y Z
1 1 1 0 0 0
2 1 0 1 1 0
3 0 0 0 0 0
Is it possible with Alteryx Designer?
Thanks!
Franck
Solved! Go to Solution.
Hi @FranckG
I have attached a sample workflow built in Alteryx 10.6.
I the used a crosstab tool to get the headers you needed with a count of the values as the methodology. I then used the data cleansing tool and dynamic rename to get the desired output.
Best,
Jordan Barker
Solutions Consultant