Forum Discussion
Solved
Check if substring from column exists inside string in another table column
I have two tables, firstone identifiants, which has id column as below : second table informations, which has information id column as below: I added a custom column check in identif...
Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?
Perhaps something like this instead:=Text.Contains(Text.Combine(informations[informations id]),[id])
Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?
Perhaps something like this instead:
=Text.Contains(Text.Combine(informations[informations id]),[id])