Forum Discussion
Solved
Expanding table in Power Query - preview shows correct value, but after expanding its incorrect
Dear comunity, I'm merging two tables to get data into first table. When I merge the two tables and click into new column to see preview of which row was mapped to the row, it shows correct value...
Your code seems rather complex. Can you strip away anything that is not relevant to the issue?
Have you considered using lookups via Table.AddColumn instead of merges?
When you expand the merge column, please also consider name and see the result