I'm trying to do something simple that I think should work in theory, but I keep getting an error. I'm trying to compare 2 lists within a custom column and return the values that match {List1, List2}
List1 = Text.Split([Keyword], " ") => [Keyword] = Mens Black Dress Shoes
List2 = Text.Split([Tag], " ") +> [Tag] = Dress Shoes
To return the match between the 2 lists, I'm using this formula inside a custom column:
List.Intersect([List1],[List2])
I'm thinking it should work, but I keep getting an error:
Expression.Error: We cannot convert the value "shoes" to type Function.
Details:
Value=shoes
Type=[Type]
Can anyone tell me what I'm doing wrong or if what I'm trying to do is not possible?
Thanks!
Hi,
List.Intersect requires the lists be supplied as a list. As written above it thinks that List2 is the 2nd optional parameter equationCriteria
let
List1 = Text.Split("Mens Black Dress Shoes", " "),
List2 = Text.Split("Dress Shoes", " "),
Result = List.Intersect({List1,List2})
in
Result
Regards
Phil
Thanks so much, Philip. Such a simple solution!
I apologize for the late follow-up. I had surgery a week and a half ago and have been slowly recovering.
Thanks again!
No worries, hope the recovery goes well.
