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
Another option can be to generate an aggregated table that is only use ffor the lookup that will group the keys and return that column value and then merge it with your final table
Solution SageYes could probably also done that. But now I was able to configure the source (removing the column with the timestamps). So no extra steps in query editor.