Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Insert without update with map operation

Hello all,

I am new to SAP BODI and I need some help in order to perform the action below :

I have a source table T1(ID, COL1, COL2) and a target table T2(ID, C1, C2),

I want to insert all the new rows from T1 into T2 based on the ID, and I don't want to update the rows that already exists in T2.

Example :

T1

ID COL1 COL2

1 AAA BBB

2 CCC DDD

3 EEE FFF

T2

ID C1 C2

1 A BBB

4 GGG HHH

After the run of my ETL script, T2 should became

ID C1 C2

1 A BBB

4 GGG HHH

2 CCC DDD

3 EEE FFF

As you can see the first line of T2 is not updated even if the ID existes in T1, but the lines with the IDs 2 and 3 from T1 are added to T2.

I tried a map operation with insert and discard the other options, it did't work and my first line is updated.

I tried to change options in the target T2 but it did't work neither and my line is always updated :\

Do you have any idea how can I do that ??

Thanks in advance icon_smile.gif icon_smile.gif

P.S : Sorry for my bad English !!

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question