Load Distinct Values While Reload And Summarize Data

[ashfaq_haseeb]

Dear All

I have data like this

Id	Code	Price
1	A	20
1	A	30
2	B	40
2	B	50

During load from databse I want to load distinct values of ID and code but i want to sum the proce for particulat id and code

the outup should be like this in table itself.

Id	Code	Price
1	A	50
2	B	90

Any Help Regarding this will be highly appreciated.

I'm attaching a sample here

Thanks and Regards

Ashfaq

[#2]

hi ashfaque,

pls see the attached application.

thanks