Data from Two tables with common reference, one takes priority

[kapilpatil]

Hell All,

In SAP DS3.2, I have data from two different Tables(TABLE1 and TABLE2) and Col1 is common between the two, is merged via merge transform. If there is same data value(Value1) from the two sources, data from TABLE1 takes priority for next steps in the logic. I would like to know how do I consider data only from TABLE1 (when Value1 is same from both tables)?

When values in Col1 are different, then data from both sources will considered.

Thanks,

Kapil

[Julian_Riegel]

Hi,

as far as I understand your requirement, you could simply use auto-correct load option on the target table and populate it sequentially, with the lower prio data first - for this you do not actually need to merge your data up-front - make sure that your reference is set as the PK in the Data Flow:

https://blogs.sap.com/2013/09/18/sap-business-objects-data-services-target-table-options/