Log In
Register
Home
February 23, 2017
Offline
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!
October 5, 2010
Offline
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
1 Guest(s)
