Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to fix table data to fill null values properly with Power Query

Hey community,   Yet again I'm unable to find resolution for a table manipulation that I'm working with. I've been trying outer join with 2 different tables (1 with correct values, and second one ...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    It's the correct strategy but the join step is incorrect.  Either the data types are incompatible OR the tables were in the wrong order OR the wrong type of join is being used.

     

    It should be a 'Merge as new' with Left Outer join kind , with the number table at the top (join on Index and Name and they should be same data type).  Then expand the table column.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

It's the correct strategy but the join step is incorrect.  Either the data types are incompatible OR the tables were in the wrong order OR the wrong type of join is being used.

 

It should be a 'Merge as new' with Left Outer join kind , with the number table at the top (join on Index and Name and they should be same data type).  Then expand the table column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey,


    Thanks a lot! Your explanation clarfied quite a bit to me. I was not that far after all. This kind of guidance actually helps to learn yourself on how to do it.