Splitting a Tree

oldtimer47 · Post by **oldtimer47** » 17 Aug 2009 21:56

I am trying to split a tree so that I am left with all individuals connected to a person.

Using the split tree helper it asks for a query to use - I have selected 'all relatives' and set the helper to delete everything else.

Problem is this leaves me with 100 relatives rather than the 583 'connected individuals' I know to be there.

Is there a better query to use ? or have I missed something - I am slightly suspicious of being left with exactly 100 people. Is there a size option I may have missed on the query?

Hope someone can help with this.

Regards
Peter

ID:3934

ChrisBowyer · Post by **ChrisBowyer** » 18 Aug 2009 05:49

I've often used split tree helper with a query like this and never come across a size limit. I haven't used All Relatives because it never quite does what I want. Are you sure you understand what it does?

It starts with the individual you name, adds all recorded ancestors and their spouses, and then adds all descendants of everyone it's already found and their spouses. That doesn't incidentally include the starting person's in-laws, nor any of their relations in-laws.

Try it in the Query window and see the who you get in the results tab. That might explain your 100 people.

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 06:06

Chris

Thanks for the reply and explanation - I did not appreciate the definition of 'all relatives' - is there any way to get the list of 'connected persons' ?

Thanks again
Peter

ChrisBowyer · Post by **ChrisBowyer** » 18 Aug 2009 06:43

I'm sure there is, but I'm hoping someone else will chip in here as I'm a bit out of my comfort zone with custom queries.

YouTube · Post by **Jane** » 18 Aug 2009 06:51

You could use the Relation Pool expression, and select everyone not in your 'main' pool, or build a custom query to add all relatives of those already in your all relatives query.

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 06:59

Hi Jane

I think I am seeing a way forward now with 'Export Gedcom'

I'd like to export everyone in a pool to a seperate Gedcom. That looks as though it should be possible.

Can you help me with the correct syntax for a custom query to select all individuals in the same pool as a selected indiviual ?

Many Thanks
Peter

YouTube · Post by **Jane** » 18 Aug 2009 08:39

Try

Code: Select all

=IsTrue(RelationPool() = RelationPool(['Root']))

In the Rows section using the is true operator in the drop down

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 10:52

Hello Jane

That looks very close but I was hoping to select an individual and then see all the members of their pool. The selected individual would not necessarily be the root.

I'll try and look at some other queries to see how they invoke the 'pick list' of individuals.

Thanks
Peter

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 12:12

Hi again Jane

I have managed to get the expression

Add if =RelationPool() equals ['X']

into a row and when run this prompts me to enter a number for X - this then gives me the correct individuals belonging to the pool X.

What I am missing is how to do a lookup - i.e. selct an indicvidual and have their pool number returned in place of 'X'.

I hope this makes sense

Thanks again - Peter

YouTube · Post by **Jane** » 18 Aug 2009 12:21

Adding the line I gave you would prompt for the person. That's what the ['Root'] bit does.

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 12:45

Hi Jane

I had one bracket too many in the expression !!!!

It works a treat. Do you think it is worth uploading as a Query for others ?

Many Thanks
Peter

YouTube · Post by **Jane** » 18 Aug 2009 12:46

Feel free to do so. Please add a good title and a few words of explanation in the query on the front page, before uploading.

kelvin · Post by **kelvin** » 18 Aug 2009 21:07

I don't seem to be able to enter the expression given

=IsTrue(RelationPool() = RelationPool(['Root']))

to try to create this query. When I do (using copy & paste) the operator drop-down menu is empty, and the Add & Update boxes are inactive.

What am I doing wrong ? I've tried everything I can think of but nothing works.

So I'd be grateful if someone could upload this query so that I can use it, or tell me what I am doing wrong ....

many thanks

oldtimer47 · Post by **oldtimer47** » 18 Aug 2009 22:45

I have tried to upload the query but it will need some help from the Admin team to make it accessible !!!

In the meantime this is how I used the General Tab to build the expression

The expression has to be exactly correct otherwise the operator box will be blank.

Hope this helps - Peter

oldtimer47 · Post by **oldtimer47** » 19 Aug 2009 07:31

Now uploaded as Linked Individuals 1

Apologies to anyone who tried to download my earlier attempt - I had posted it to the incorrect folder !!

Hopefully Admin will delete the invalid entry in the Fact Sets Folder

Peter

kelvin · Post by **kelvin** » 19 Aug 2009 10:00

Thanks Peter for uploading it.

BUT, it still doesn't work on my system !!! I downloaded it and when I check the Rows section it is empty. If I look at the query file using a text editor I can see that the filter expression is there.

Is it because I am still using Version 3.1.2 of Family Historian I wonder ? Perhaps Jane would be so kind as to check if that functionality is only valid in Version 4. If so perhaps the query should be flagged as such. If not then has anyone any ideas of why it won't work on my version ?

Thanks
Kelvin

JonAxtell · Post by **JonAxtell** » 19 Aug 2009 10:35

This IsTrue function is only available in V4.

YouTube · Post by **Jane** » 19 Aug 2009 11:10

As Jon says, the Istrue() function and comparison is only available for V4. The closest you could get on V3 would be to look up the pool number and then use that as a parameter.

I have amended the title of the Query to make it obvious it's only valid on V4.

Family Historian User Group

* Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree

Splitting a Tree