Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Require help for a problem faced

Eug_teng
7 - Meteor

Hi all, 

 

I was stuck on this one problem which I hope I could get some help! I have a separate list of codes and a list of combinations of codes (see examples below:)

 

List of Combinations
a
b
c | d
b | d
a | e
e
b | e
d | e
d

 

Codes
a
b
c
d
e

 

Firstly, I would like to make the join them together and make the Codes my headers, and for every code that appears in the combination, the result would be "1", else "0". See expected results below

 

List of Combinationsabcde
a10000
b01000
c | d00110
b | d01010
a | e10001
e00001
b | e01001
d | e00011
d00010

 

Hope to get some insights on this thank you!

2 REPLIES 2
grazitti_sapna
17 - Castor

Hi @Eug_teng , try this if it helps.

 

grazitti_sapna_0-1600940048009.png

 

If this is what you are looking for kindly give a thumbs up and mark this post as solution.

Thanks.

Sapna Gupta
wdavis
Alteryx
Alteryx

Hi @Eug_teng 

 

I have attached a workflow which gets to your expected output.

 

Let me know if you have any questions on the workflow, as I haven't added in any annotations, but it should be relatively clear!

 

Kind Regards

Will

Labels