Forum Discussion
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, P...
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