Forum Discussion
Solved
Comparing 2 tables - missing info in one table
hello,
I am having issues comparing 2 tables.
I hae a column called CUID (is a unique customer number.)
the idea is to compare a Baseline Extract with current data
to ...
Hi,
Could you do this in power query, merger the tables on a anti join to show only records that appear in one?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Another solution in Power Query would be to create a list of the baseline CUIDs and then create a column in the current file that uses List.Contains to look for the current CUID in the baseline list.
Hi,
Could you do this in power query, merger the tables on a anti join to show only records that appear in one?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍