boolean column creation based on string extract from a column

[shikhar6339]

Hi,

I have a column where each record have multiple people's name. E.g.: I have 6 people - ABC, DEF, GHI, JKL, MNO, PQR.

Now I want to create 6 columns with 1 or 0 values with each person's name whether the first column has his her name.

in the table below, I have only 1 column: Name. I want to create remaining columns with 1/0 values.

Name	is ABC	is DEF	is GHI	is JKL	is MNO	is PQR
ABC GHI JKL	1	0	1	1	0	0
DEF MNO GHI	0	1	1	0	1	0
PQR ABC JKL	1	0	0	1	0	1
DEF JKL	0	1	0	1	0	0
DEF GHI ABC JKL	1	1	1	1	0	0

Really appreciate your help.

[binuacs]

@shikhar6339 

One way of doing this

[shikhar6339]

Hi,

Thank you for your suggestion. I was working on it and found another way in which I'll only have to use 1 formula tool and create 6 formulas like: if Contains([Name], "ABC") then 1 else 0 endif

[nagakavyasri]

@shikhar6339 Try this instead of creating multiple formulas: