Forum Discussion
rpinxt
Solution Sage
Solution SageMerging issue where a line gets doubled when pulling in field from merged query
I have this simplified setup in power query editor: Two runs, one at 10 and another at 10:30. Now first run the delivery had status To Pack and second run it had status Done. And the deliver...
Hi rpinxt ,
Since your keys are matching for all rows you get more than one line for each one:
When you expand you get two rows. In this case you need to select the aggregation and not the expansion:
One row per each one
Be carefull on this merge since if there are for the same key more than one Storage type you will only get the maximum, you can also select the minimum or make it in a different way.
