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]

Gertye,

tell me what is your goal. What you need in application. I can imagine that user selects 2 persons and application shows shortest distance (or maybe this distance and path).

Is it anything else you would like to do from those data in application?

regards

Darek

[#3]

this table it's source table for my qlikview model

I need to define relations between people and generate family_ID

After that users of my qlikview model will be able to see family members. They will be able to learn any person Family_ID and then(select Family_ID) to know who is entering person family. That's all.

[#4]

Gertye,

so, i understand that if it is any path from one person to some other person (it is not importank how long it is) - those persons will get the same family id? You, in fact, are not interested what is the distance....

regards

Darek

[#5]

You, in fact, are not interested what is the distance....

That's right

[preminqlik]

hi ,

please find attachment

[#7]

Let me know if  it is true, that:

We can assume, that reload is incremental. We know some families defined earlier (during earlier reloads) and you need to incorporate new contacts (pairs of persons). Each pair can:

-build new family (if we dont know any person from this pair),

- connect to one existing family (if we found 1 existing family for this pair)

- cause, that 2 families become one family (we know both persons but they were in another families).

Is it possible that some earlier defined pairs will be dropped in the future?

Regards
Darek

[#8]

Let me know if  it is true, that:

We can assume, that reload is incremental. We know some families defined earlier (during earlier reloads) and you need to incorporate new contacts (pairs of persons). Each pair can:

-build new family (if we dont know any person from this pair),

yes

- connect to one existing family (if we found 1 existing family for this pair)

- cause, that 2 families become one family (we know both persons but they were in another families).

yes

Is it possible that some earlier defined pairs will be dropped in the future?

I don't think so. My user needs to have contact with people in family. If person1 in marriage divorse with person2, my user still can call to person1 for to ask about person2. It's eternal connection

[#9 · Accepted solution]

Prem,

i prepared example for you.

Do few "incremental" reloads and look how families are rebuild after them.

1.  save attached files in d:\

(or in other location, but then change pathes in script)

2. reload and look

3. put new data into sheet1 (Arkusz1) of xls

4.reload ....., reload ....

Let me know what do you think about it.

regards

Darek !

[#10]

Hi

Thanks for help!

[#11]

That's it!

Darek, thank you.

You offered a good solution, I want  use it, if you do not mind...