Skip to Content
0
Former Member
Aug 05, 2016 at 12:15 PM

SAP BODS - Capture cross matching data

49 Views

I have a scenario in BO Data Service where I need to identify the cross matching data from a table.

This is my source data

ROW_ID OLD_CODE OLD_OPT_CODE NEW_CODE NEW_OPT_CODE 1 1000 F 1000 F 2 1000 F 1000 H 3 1000 H 1000 F 4 1000 H 1000 H

The output needs to be like this

ROW_ID OLD_CODE OLD_OPT_CODE NEW_CODE NEW_OPT_CODE 1 1000 F 1000 F 2 1000 F 1000 H 4 1000 H 1000 H

Here if OLD_OPT_CODE and NEW_OPT_CODE are same in a row then it should go to target table.

And if OLD_OPT_CODE of a record is same as NEW_OPT_CODE in another row and vice versa (like ROW_ID 2 and 3 from above source), then only the first record should be inserted into the target table.

Can you please suggest a solution for this? I can not use DQ transformations.

Thanks

Theju