Removing Duplication?

[navaneeth79]

I have a table for example

ID,Time

A,120

A,230

A,100

B,50

B,100

I want to store this table in qvd as

ID,TIme

A,450

B,150

So I can use that Qvd in other application

[kaushiknsolanki]

Try this.

RawData:

Load * inline [

ID,Time

A,120

A,230

A,100

B,50

B,10

];

Aggregate:

noconcatenate Load ID, Sum(Time) as Time Resident RawData group by ID;

Store Aggregate into Aggregate.qvd;

Regards,

Kaushik Solanki