Forum Discussion
Table.ExpandTableColumn returning null values
I've joined these... When hovering over the 'tblRWtømningsdag' field, I get the following values: However, when expanding 2 of the columns, I get null values returned: What...
It'd seem like the issue was related to lowercase/uppercase values.
There was an actual in uppercase/lowercase between the 2 joined tables, and still Power Query Editor showed me the table data in the preview (surely an error?) but nothing when expanding (as expected).
Transforming the values in the joined column in both tables to uppercase before joining helped.
It'd seem like the issue was related to lowercase/uppercase values.
There was an actual in uppercase/lowercase between the 2 joined tables, and still Power Query Editor showed me the table data in the preview (surely an error?) but nothing when expanding (as expected).
Transforming the values in the joined column in both tables to uppercase before joining helped.