Forum Discussion

009co's avatar
009co
Helper IV
4 years ago
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...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    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.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

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.