Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

list.intersect not working case?

Hello, I need to make List.Intersect but found case I am not able to resolve. I tried to simplify to maximum my issue. I have two tables. - One named TPR contains two fields : a identified of issu...
Need Help
  • Smauro's avatar
    Smauro
    5 years ago

    Hi Anonymous 

     

    Could be the case that your column has more characters not shown. Try using Text.Clean on it before adding the new columns.

    More, you should use List.ContainsAny , which should be a faster calculation .

    Best,

    Spyros

Smauro's avatar
Smauro
Solution Sage
5 years ago

Hi Anonymous 

 

Could be the case that your column has more characters not shown. Try using Text.Clean on it before adding the new columns.

More, you should use List.ContainsAny , which should be a faster calculation .

Best,

Spyros