The data file to be exported has two cases, with three records in each case; one Housing record (record type=1) and two Person records (record type=2). The ID consists of two items (IDA and IDB), the Housing record (max records=1) has two items (HM and HN), and Person records (max records=5) have two items (PX and PY).
<ID1, Housing 1> or <IDA1, IDB1, HM1, HN1>
<ID1, Person 11> or <IDA1, IDB1, PX11, PY11>
<ID1, Person 12> or <IDA1, IDB1, PX12, PY12>
<ID2, Housing 2> or <IDA2, IDB2, HM2, HN2>
<ID2, Person 21> or <IDA2, IDB2, PX21, PY21>
<ID2, Person 22> or <IDA2, IDB2, PX22, PY22>
If exported to 'one file' and 'all in one record,' two records are written to that file, one for each case.
<IDA1, IDB1> < HM1, HN1><PX11, PX12, ..., PX15, PY11, PY12,..., PY15>
<IDA2, IDB2> < HM2, HN2><PX21, PX22, ..., PX25, PY21, PY22,..., PY25>
For the items on the person record, five occurrences are listed (max records = 5) even though PXn3 through PXn5 and PYn3 through PYn5 are blank.
If exported to 'multiple files' and 'all in one record,' two files are created. The Housing file will have two records:
<IDA1, IDB1> <HM1, HN1>
<IDA2, IDB2> <HM2, HN2>
The Person file will have two records:
<IDA1, IDB1> <PX11, PX12, ..., PX15, PY11, PY12,..., PY15>
<IDA2, IDB2> <PX21, PX22, ..., PX25, PY21, PY22,..., PY25>
Five occurrences are listed (max records = 5) even though PXn3 through PXn5 and PYn3 through PYn5 are blank.
If exported to 'multiple files' and 'as separate records' but Housing not joined to Person, two files are created. The Housing file will have two records:
<IDA1, IDB1> <HM1, HN1>
<IDA2, IDB2> <HM2, HN2>
The Person file will have four records:
<IDA1, IDB1> <PX11, PY11>
<IDA1, IDB1> <PX12, PY12>
<IDA2, IDB2> <PX21, PY21>
<IDA2, IDB2> <PX22, PY22>
If exported 'as separate records' and 'join single with multiple,' ONLY one file is created regardless of whether 'one file' or 'multiple files' is selected.
<IDA1, IDB1> <HM1, HN1> <PX11, PY11>
<IDA1, IDB1> <HM1, HN1> <PX12, PY12>
<IDA2, IDB2> <HM2, HN2> <PX21, PY21>
<IDA2, IDB2> <HM2, HN2> <PX22, PY22>
The dictionary corresponding to the data files has two levels. Level 1 contains data on a mother. Level 2 contains data on the mother's children. Each level may have several record types.
If you export to one file, each level's data will be written to a separate record. The output file would contain the following records:
<Level 1, all records concatenated> (Mother A)
<Level 2, all records concatenated> (Child 1 of Mother A)
<Level 2, all records concatenated> (Child 2 of Mother A)
<Level 2, all records concatenated> (Child 3 of Mother A)
<Level 1, all records concatenated> (Mother B)
<Level 2, all records concatenated> (Child 1 of Mother B)
<Level 2, all records concatenated> (Child 2 of Mother B)
<Level 2, all records concatenated> (Child 3 of Mother B)
...
The order of items would follow the pattern shown in Example 1.
The data file to be exported has two cases with three record types, the following records in each case.
<Housing 1>
<Person (man) 11>
<Person (woman) 12>
<Person (child) 13>
<Fertility 11>
<Housing 2>
<Person (women) 21>
<Person (child) 22>
<Person (women) 23>
<Person (child) 24>
<Person (child) 25>
<Fertility 21>
<Fertility 22>
Each Person record representing a women has a corresponding Fertility record associated with it through a relation defined in the dictionary.
If you export Person and Fertility records to one file and as separate records, you will get one file with the following three records:
<Person (women) 12>< Fertility 11>
<Person (women) 21>< Fertility 21>
<Person (women) 23>< Fertility 22>