Skip to Content
Jan 20, 2011 at 09:18 PM

Update multiple rows of DSO from Datasource



We have a custom DSO with 4 key characteristics. It is initially populated by a custom datasource correctly.

We now need to update some of the data fields using a standard datasource, but it only has two of the key fields available.

In the transformation from the datasource to this DSO, I have generated an internal table in the start routine to collect the additional two key fileds from the DSO table.

I was wondering if there is a way to loop through when loading to update all the rows for the other two keys?


DSO - load from custom datasource:

K1 K2 K3 K4 D1 D2

a b c d 1 2

a b e f 3 4

standard datasource

K1 K2 D2

a b 8

We would like to use the data from the standard datasource to update both rows in the DSO to populate data column D2 with the value 8.