Why does it create a remove function after a merge?

[fatima13]

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!

[BA_Pete]

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