Transposition of fields

[FranckG]

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

[JordanB · Accepted 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