Forum Discussion

fatima13's avatar
fatima13
Regular Visitor
3 years ago

Why does it create a remove function after a merge?

Hi!

 

I've been struggling with this problem for a few days:

 

I want to join two tables with a merge (they have 4 common columns). I use an inner merge and then I save & close and, after that, Power Query itself creates a new remove function and they remove some of the columns I need. Even if I edit the tables and remove de function, when I save and close again, they automatically create the remove function again.

 

Can someone help me with this problem?

Thank you in advance!

 

Need Help

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi fatima13 ,

     

    My guess is that Power Query is doing this as an error-handling step to allow the query to load correctly.

    Without being able to see the all the queries/code it's hard to be sure, but I'd check for duplicated column names as a result of the merge. This is particularly likely if you're using the Table.Join function rather than Table.NestedJoin.

     

    Pete