Forum Discussion

warnera's avatar
warnera
Icon for Helper I rankHelper I
6 years ago
Solved

Finding unique text in 2 different columns

Hello all, I am trying to create a column that displays only the unique text shared between two columns. Created sample example below. Will be working with large dataset.    Column A               ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  warnera 

    You just miss "{ }' in this formula

    just adjust it as below:

    Text.Combine(List.Intersect({Text.Split([Column A],",") ,Text.Split([Column B],",")}),",")

    Result:

     

    Regards,

    Lin

warnera's avatar
warnera
Icon for Helper I rankHelper I
6 years ago

I was also unable to replicate this on a test example. 

 

 

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

HI  warnera 

You just miss "{ }' in this formula

just adjust it as below:

Text.Combine(List.Intersect({Text.Split([Column A],",") ,Text.Split([Column B],",")}),",")

Result:

 

Regards,

Lin