Solved: Re: Table.ExpandTableColumn returning null values

Anonymous · ‎05-02-2023

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 could explain this behaviour - and what's the fix?

This is Excel PowerQuery by the way.

Thanks in advance for any help.

Anonymous · ‎05-02-2023

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.

View solution in original post

Anonymous · ‎05-02-2023

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.

Payeras_BI · ‎05-02-2023

Hi @Anonymous ,

Difficult to tell without having a sample file to reproduce the issue but check the use of Table.Buffer function and see if would be of any help in this specific scenario.

Regards,

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain