Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have merged 2 tables to be a full outer Join by Address field. When I check the join column in the 2nd table, it indicates null ( concluding that no record was matched). However, when I highlight the row and view the details in the record selection the Column is populated correctly.
Also, when I filter on null values from the 2nd column the record does not appear, weven though it indicates null for that record. The 2nd joined column does not appear as null when exported to a table either. ( I've tried restarting, refreshin, redoing the merge and renaming the workbook, and each time this occurence is still evident).
In the image below you can the record is highligted and indicating null but displaying and address value in the record selection pane at the bottom.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.