How can I add duplicate records in an ODS?

[Former Member]

Hi guys,

I have an input file that may contain dupplicate records for the key. I am having trouble loading to an ODS because the key is duplicated. Is there a way to have one register in the ODS with sum of the duplicate records?

Ex:

Input File:

YEAR COMPANY VALUE

-

---

2007 COMPANY1 2.00

2008 COMPANY1 2.00

2008 COMPANY1 2.00

2008 COMPANY2 2.00

Expected data in ODS:

YEAR COMPANY VALUE

-

---

2007 COMPANY1 2.00

2008 COMPANY1 4.00

2008 COMPANY2 2.00

help will be rewarded

Thx

DGF

[Former Member · Accepted solution]

uncheck the option Unique Data Records in the DSO and make the Key figures as addition.

[Former Member]

Hello David,

Change the key figure aggregation behaviour from Overwrite to addition.

Nick