Finding other children

[#1]

Hi,

I have a list of names for parents and their kids. Every kid has one family and one family can have several kids. What I want to do know is to find one child's siblings by selecting that kid. For example: the Smith family have four kids, Aiden, Daniel, Matthew, and Elijah. Now if I select Aiden, I would like the table to show me the entire family, that is the names of all his siblings. I have attached a file, please have a look!

Cheers,

[#2 · Accepted solution]

Hi Nils

here is one possible solution

best regards

Chris

[sujeetsingh]

Chris

Can you please explain the qualify and unqualify function ??

[#4]

this works perfectly! thank you!

would you mind however explaining a bit what you have done here ?

[#5]

QUALIFY *  will prefix the field names by the name of the table

let's say

T1:

Load A, B, C....from ....

will give T1.A, T1.B, T1.C

this is an automatic alias

unqualify field name will revoke Qualify for indicated fileds or * (all)

best regards

chris

[#6]

tnx. how does the binary function enter in to this? and where do you actually load the data? i would have expected a FROM statement somewhere ....

[#7]

Nils

binary loads your qvw because I hadn't the xls file.

I added a second table link to your original thru Parent (actually don't do this but load a specific key in both tables like Parent as %P and unqualify %P)

So both tables are the same of deliver a 1 to n relation

best regards

chris

[#8]

ok, so if i understand you correctly i can achieve the same thing by doing something like:

Main:

LOAD Parent,

     Child,

     ChildFullname,

     Month

FROM

(biff, embedded labels, table is Sheet1$);

T2:

LOAD Parent,

     Child as T2.child,

FROM

(biff, embedded labels, table is Sheet1$);

[#9]

Yes  exactly

but my advice is you duplicate PArent field as %P because it is not recommanded to use key in graphs

best regards

Chris