DSXchange

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.

Hi,

Can you verify the 'Group Identification Column' in the Survive GUI is set to 'qsMatchSetID'.

The fact that you got more than one record per qsMatchSetID tells me you forgot to set that.

By the way, with your rule, you should expect to see:

qsMatchSetID:1 qsMatchDataID:1 qsMatchType:MP Source:S1 Name:name1
qsMatchSetID:2 qsMatchDataID:4 qsMatchType:DA Source:S1 Name:name4