Forum Discussion
list.intersect not working case?
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
Hello Anonymous
The result is perfectly fine
The item TOP155G20ATDD10MPBlocker is not in the list created from this TOP15G20ATDDP7Blocker,TOP15G20ATDD10PDBlocker,TOP15G20ATDDP8Blocker,TOP15G20ATDD01MPBlocker,TOP15G20ATDD10MPBlocker,TOP15G20ATDDeCPRIP7Blocker,TOP15G20ATDDeCPRI10MPBlocker.
Only the item TOP15G20ATDD10MPBlocker... that is not the same. one time 15G and the nother 155G
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy
Good point, I made a typo reporting my problem but the problem is there. Is there a way to share my .pbix? I see a possibility to share a link but I don't see where to attach a file...
Stchln
Hello Anonymous
you can load it to some fileshare (like onedrive) and put the link here.
But did you change the content of your first row without success?
BR
Jimmy
Jimmy
My first row was correct, only my text posted was wrong. but even, I did insert a dummy TX and it failed as well.
I will try the Text cleanup recommended or make some dichotomy to understand where it starts failing...
Hi Smauro
The List.ContainsAny could find it, many thanks!
Custom = List.ContainsAny(Text.Split([TOP],","), Text.Split(TFLT[TOPL]{0},","))
Thanks also to Jimmy for his support
Stchln