Jump to content


Intersection of trees in file


  • Please log in to reply
4 replies to this topic

#1 Guest_Jim_*

Guest_Jim_*
  • Guests

Posted 19 June 2004 - 09:38 PM

Is there away either thru roots magic or some other means to find where a couple of "virtually" non related trees might intersect? I've imported some data (long time ago) that had extensive trees that only have one or two connections to mine main lines. I'd like to break them at the intersections but have no idea where that might be (there are some 10,000 people in this file).

Didn't know if there was some way that RootsMagic or some other program that would give you a bird's eye view of a tree that could show where the branches get thin.


Thanks,

-- Jim


#2 Guest_Wayne League_*

Guest_Wayne League_*
  • Guests

Posted 20 June 2004 - 03:35 AM

If you have two people in the same database tree who are not related to each other at all, and you want to find out where their branches intersect, then make a kinship list from the Roots Magic Reports, one for each of the two people. Print them out and compare them. Wherever you find the same person(s) on both lists, that is where the branches intersect. (Go by the record numbers to avoid confusing similar names).

This could be a daunting task if your database is large. I don't know of a program that will compare and find the same names/numbers in two different lists like this.
If anyone knows of a utility program that will do this, please let us know.

Wayne League


#3 Guest_Wayne League_*

Guest_Wayne League_*
  • Guests

Posted 20 June 2004 - 08:53 PM

OK, Jim, you can send your two kinship lists to RTF files and import them both into an Excel Spreadsheet. Then you can use the Excel "COUNTIF" formula to highlight the names appearing in both lists and thereby locate the connection(s) between the two.

For instructions on how to do this, go here:
http://www.j-walk.co...tips/tip073.htm

Wayne

#4 usma79

usma79

    Member

  • Members
  • PipPip
  • 6 posts

Posted 28 June 2004 - 09:37 PM

How about using color?

Color all the ancestors in one tree and go through the other tree until you find that color. Will take some time, that is for sure.

#5 Guest_Wayne League_*

Guest_Wayne League_*
  • Guests

Posted 29 June 2004 - 12:22 AM

QUOTE (usma79 @ Jun 28 2004, 08:37 PM)
How about using color?

Color all the ancestors in one tree and go through the other tree until you find that color.  Will take some time, that is for sure.

Problem is, two people who are not related to each other are not going to have ANY common ancestors. If they did, then the relationship calculator would quickly show their relationship and they would be cousins (ie: related). You're looking for someone related to both primaries and yet not in the direct line of either. It will most likely be some sort of cousin or the spouse of a cousin.

As yet, there is no kinship selection on the select persons list that you could use to color code only the people related to a person. If there were, and if the color coding showed up in the explorer/select people list then color coding could be used to find the connection(s). (After considerable scrolling in a large database)

Having color coding show on the explorer has already been wished for in the wish list. If others are interested in having a kinship selection in the select persons list then you might put that on the wish list also. Although this topic is a sort of "off the wall" reason for having a kinship selection, it would come in very handy if you wanted to send your cousin a gedcom file from your database that contained only his own relations.

Wayne