Forum Discussion
Solved
Table value comparsion
Hi - I am looking to do the following in my Power Query workflow. I would like create a table of values not found comparing two tables. Example: Table 1 MS-ID AC-ID 1 500 1 600 2...
Yes:
= Table.NestedJoin(Table1, {"AC-ID", "MS-ID"}, Table2, {"AC-ID", "MS-ID"}, "DeleteThis", JoinKind.LeftAnti)
Why that sounds like a LeftAnti join.
Yes:
= Table.NestedJoin(Table1, {"AC-ID", "MS-ID"}, Table2, {"AC-ID", "MS-ID"}, "DeleteThis", JoinKind.LeftAnti)