How to identify the chain?

[#1]

Hello

I have source with structure: SOMEONE1, SOMEONE2, family_identifier.

SOMEONE in one row can be associated with someone from a different row. Thus, in the family for 3 person. And so on ...

Help me identify the chain effective way?>

[#2]

You have to do accurate tests first .... I had not enough time to carefully check all the cases. But as a starting point for your palikacji I hope it will be ok

Check also how it works with your data volumes.

reg

D

[preminqlik]

sorry guys that i cannot cat you people ,as am off to home from ofc,

yes dariusz , need to do some R&D for clear cut. thanks for explanation.