Find twins -- create list or group

RootsMagic
1

I can do this outside of RM - but I really do not think there is a way to do effectively within RM – want to find all persons with sibling (or with same FamilyID) that has the same Birthday (mm-dd-yyyy), I can do this outside of RM – for example in FTAnalyzer – if has same birth in same familyID (and/or Surname). I could also do with Sqlite. (or dump into other software that has method)
Just wondered if I was overlooking something in RM. Ps. this would also include triplets and more (but in most cases twins)

2

I can’t think of a way to do that in RM. I have added twin in the birth description field so I’m able to search and find mine that way.

1 Like
3

Thanks – yes my plan is to create (Share Birth Fact) with Twin (or Triplet) Role.
I do understand that Shared Facts may not work outside of RM and not work with TreeShare.

However, I needed the list to do so. One option/workaround is Family Tree Analyzer & Excel (Pivot Table). 2nd for me was to use Family Historian (which has great query language)

IsTrue(
(%INDI.BIRT.DATE% = Field(NextSib(%INDI%),'INDI.BIRT.DATE')
)
or
(%INDI.BIRT.DATE% = Field(PrevSib(%INDI%),'INDI.BIRT.DATE')
)
)
4

This is not as slick as a SQL query and requires multiple steps but it works within the RM toolset.

You could create a custom report with name, rin, dob and export to excel. Then use Excel’s tools to find duplicate DOB values – pivot on DOB and examine all records where count DOB>1 or sort the workbook by DOB and add a formula to look for cells where the DOB repeats in consecutive rows.

1 Like
5

Actually I thought of that but good suggestion and work around.

1 Like
6

I created a fact called Twin as I have many sets of twins in my family and which I can use in a custom report to find all twins in my family. When entering the description I put Twin of ???, where ??? is the name of the Twin.

1 Like
7

You can easily create a group then create report and such from the group (or you could use a color in a color set (one color for twin another for triplets for example).
Replace “Arrival” with “Twin” and make sure use Exist IsTrue

image
image849×357 9.86 KB

for me I would do in SQLite and manipulate that way

8

Here’s the SQL script I use to find multiple births that I’ve yet to identify. The output lists the first person in the multiple births. Then I go into RM and share the birth fact with a role type of “Twin” for each person with the same birth date. I’ve modified the birth fact type sentence to be:

[person:cycle]<, twin <%brother |sister |>of [Twin:First],> was born< [Date]>< [PlaceDetails]>< [Place]>.

The sentence template for the twin role is blank.

–Find Twins, etc in RM database
select PT.PersonID, NT.Given, NT.Surname, ET.Date, PT.ParentID, WT.WitnessID
from PersonTable as PT
inner join EventTable as ET on ET.OwnerID = PT.PersonID
inner join NameTable as NT on NT.OwnerID = PT.PersonID
full outer join WitnessTable as WT on WT.EventID = ET.EventID
where ET.EventType = 1 /birthday/
and ET.OwnerType = 0 /*individual event type /
and PT.ParentID <> 0 /0 has no parents/
and ET.date <> ‘.’
and NT.IsPrimary = 1 / not and alternate name */
and WT.WitnessID is null /*only those multiple births not previously identified /
group by PT.ParentID, ET.Date
having count() > 1
order by PT.PersonID

1 Like
9

Thanks for posting this. I tried it out (after correcting the corruption caused by the message editor) and found that alternative births having the same date resulted in individuals being self-twinned. Realising that it would be a useful tool to be able to list twins, I tackled it a different way at