Forum Discussion
Solved
Path error
Not sure why Path function works well when the column values are numbers but does not work when the column values are text. Could you please help me with this?
Hi,
I assume the first table with blank has a value (blank-value) in column2, while the second table column2 blank shows null value.
Please try changing the blank-value like below in power query editor and then I believe you can see the expected result.
Hi,
I assume the first table with blank has a value (blank-value) in column2, while the second table column2 blank shows null value.
Please try changing the blank-value like below in power query editor and then I believe you can see the expected result.