Forum Discussion
Solution SageMerging issue where a line gets doubled when pulling in field from merged query
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.
Super UserHi rpinxt ,
Since we do not have the base file (Merge doubling issue.xlsx) I can check the merging however what I can see is that when you do the merge you are getting more than one value since you are making the merge based on a single field so you get not only the Done or To pack in each line of the merge but you are getting all of them.
In this case you need to force the merge to be done in a one one line.
If you can share the sample XLSX I can try and give you a better answer.