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.