Basiclly, I need to survive data by priority of source systems.
Here is the sample data:
qsMatchSetID qsMatchDataID qsMatchType Sourc_System Name
1 1 MP S1 name1
1 2 DA S2 name2
2 3 MP S1 name3
2 4 DA S1 name4
The business rule is "S2 has higher priority over S1, in other words, survive S1 (MP) record only if there is no S2 record". In this example, record 2 and 3 should survive:
qsMatchSetID qsMatchDataID qsMatchType Sourc_System Name
1 2 DA S2 name2
2 3 MP S1 name3
I tried to use something like this: rule1 AllColumns qsMatchType="MP"
rule2 AllColumns urc_System<>"S1"
Instead I got this:
qsMatchSetID qsMatchDataID qsMatchType Sourc_System Name
1 1 MP S1 name1
1 2 DA S2 name2
2 3 MP S1 name3
How to design the Survive rules?
Thanks.