Forum Discussion
Solved
Power Query merge creating multiple replicate columns - weird never seen this behavior before!
I have used merge 100's of times in many situations .. left, inner, full joins, etc but have never seen this weird behavior before. Data Table - location column has many values (fact table) Loca...
Hi, 009co
Based on the information above, what seems to be happening here is that the merge operation is getting all the columns instead of the matching ones. It's not clear if it's because the special column you want to expand isn't checked but the entire table.
It would be easier to analyze what happened if the M query code was attached here.Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried clearing the cache in the Query Options?
--Nate