I'm trying to turn a table with a lot of repeated information in each of the rows into a more condensed version with less duplicates.
Within a Query, the main option I see is "Aggregate". However, for the "Group By", option I'm only limited to use one column for this and lose access to the rest of the columns that I'm trying to access. Is there a workaround for this or another way that I can condense the table?
Hi Micah,
According to DataMiner Help, from 10.3.3/10.4.0 it should be possible to apply multiple GroupBy operations.
Hope it helps.
Hi Miguel,
I didn’t consider adding additional “Group By”. That worked perfectly! Thank you!