Matching 'Consecutive Match results'

[vairus]

Hi all,

I am currently facing a problem in my matching consecutive runs.

After my first run i got result with some multiple matchset with identical matchsetid. In the second run if the same company record comes in .it should go in same matchset of the first run.

See the below example and help me with this.



Example:
first day input table

Clientcode name

100 ibm websphere limited
200 ibm websphere ltd
300 IBM websphere ltd
400 ABC corp
500 ABC CORPORATION

first day matching result

Code name qsmatchsetid gu_id
100 ibm websphere limited 1 5A
200 ibm websphere ltd 1 5A
300 IBM websphere ltd 1 5A

400 ABC corp 2 8H
500 ABC CORPORATION 2 8H





second day data:

code name
900 ibm websphere ltd
1000 xyz ltd
1100 ibm websphere limited


Expected result

Code name qsmatchsetid gu_id
100 ibm websphere limited 1 5A
200 ibm websphere ltd 1 5A
300 IBM websphere ltd 1 5A
900 ibm websphere ltd 5 5A
1100 ibm websphere limited 5 5A

400 ABC corp 2 8H
500 ABC CORPORATION 2 8H



in the third day if the records of ABC corporation comes it should go in the old ABC matchset.

i dont want same qsmatchsetid. i included to show it is matched together.

Is there any option available in qualitystage to meet this requirement.

[ray.wurlod]

I don't believe that the Transfer stage still exists in version 8. But you could do the same thing with a Transformer stage.