Return 0/1 if a unique value is found in another column.

[George_H]

Hello!

I want to do a test to see if a ID appears in another table that is a subest of the data. 

So for example:

3   1   0

4   2   0

5   3   1

     5   1

     6   0

I feel like there might be a easy soultion to do, but just can't find anything online! 

Thanks!

[v-stephen-msft · Accepted solution]

Hi @George_H ,

You could achieve it by merging tables.

LEFT OUTER JOIN

Expand the column.

Add a conditional column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dinesh_Suranga]

@George_H ,

Hi,

Try Text.Contains function.

Thank you.