Forum Discussion
Solved
How to filter a column from items in another dataset column
I have two datasets and I want to filter a column in the first dataset against matching items in a column in the second dataset they are both string columns. I'm trying to build a visual that will s...
You should be able to use List.Contains to filter the table.
Consider the example data...
itemTablecriteriaTable
you can select rows from itemTable that are not in the criteriaTable adding this line to itemTable
= Table.SelectRows(PREVIOUSSTEP, each not List.Contains(Table.ToList(crtiteriaTable), [Item]))
if you wanted to select rows that matched the criteria, you would remove the 'not' from the above code.
Hope this gets you pointed in the right direction.
Jonvoge
Most Valuable Professional
Most Valuable ProfessionalHi DJH1
You may also consider using a Merge action.
Perform a Left Join, and filter out the subsequent rows where columns from Dataset 2 are empty, meaning that no corresponding item was found.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.