Forum Discussion
If Substring from a List contains Subtring, return that item from the list
I have a column containing broken/good domains
I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]
= Table.AddColumn(Test, "Random", each List.Select([Column1],each List.Contains(TheTableNameWhichEmailDomainComesFrom[Email Domain],_,(x,y)=>Text.Contains(y,x))))
3 Replies
List.Select([Column1],each List.Contains([Email Domain],_,(x,y)=>Text.Contains(y,x)))
It keeps giving this error. I always run into this field access issue in other projects too
I have tried assigning the column to a variable but to no avail.= Table.AddColumn(Test, "Random", each let Column1 = [Column1] in List.Select(Column1,each List.Contains([Email Domain],_,(x,y)=>Text.Contains(y,x))))Just to be clear [Column1] contains lists of the correct domains
Thanks 🙂= Table.AddColumn(Test, "Random", each List.Select([Column1],each List.Contains(TheTableNameWhichEmailDomainComesFrom[Email Domain],_,(x,y)=>Text.Contains(y,x))))