Require help for a problem faced

[Eug_teng]

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 Combinations	a	b	c	d	e
a	1	0	0	0	0
b	0	1	0	0	0
c | d	0	0	1	1	0
b | d	0	1	0	1	0
a | e	1	0	0	0	1
e	0	0	0	0	1
b | e	0	1	0	0	1
d | e	0	0	0	1	1
d	0	0	0	1	0

Hope to get some insights on this thank you!

[grazitti_sapna]

Hi @Eug_teng , try this if it helps.

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

Thanks.

[wdavis · Accepted solution]

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