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 HThe 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 HHere 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