Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
174
Views
Topic starter
I use Power Query to merge two tables with Left-Anti. After merge, all columns on the merged table (the 2nd table) contain "null" instead of numbers (or values).
Can anyone tell me why this happened or if I did anything wrong?
Thanks!
Posted : 27/05/2023 5:36 pm
A Left-anti join returns rows than exist only in the first table. Could it be that all rows from the first exist in the second? Then the result will be all nulls.
Posted : 27/05/2023 11:54 pm
