Forum Discussion
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 ...
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.
Mariusz
Community Champion
Community ChampionHi Anonymous
Please see the attached file with a solution.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hey,
The attached file was exactly what I was looking for - thanks! Used this and the second reply to get the desired outcome. This was the straight answer.