donkey shrek
New Member
- Joined
- Nov 15, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
I am trying to check if there are any exact matches between [Email Domain] (contains a single domain) and [All Matches] (contains a bunch of domain).
However, it keeps returning the error below
Initial State
\
Code
I converted [All Matches] to lists using Text.Split so I could use the List.FindText function
After I run this query, all records of [All Matches] turn into the errors as shown above
However, it keeps returning the error below
Initial State
Code
Power Query:
= Table.TransformColumns(#"Grouped Rows",
{"All Matches", each let EmailDomain = [Email Domain] in if List.FindText(Text.Split(_, ","), EmailDomain) = true then EmailDomain else [All Matches]}
)
I converted [All Matches] to lists using Text.Split so I could use the List.FindText function
After I run this query, all records of [All Matches] turn into the errors as shown above