xml ouput stage Repeated Header Problem.

[sunnymdatastage]

Hello Group,

I am using XML output stage. My ouput at this point is 1 and my desired ouput is 2. Please let me know what needs to be done in order to get an ouput like 2. My header are repeating , but my requirement is to have the header(open and close) only once and the childs to be repeated for every input row.
1)
<Data reportingOrgCode="" dsProcTime="" pfBatchUUID="">
<staffMember pfTransactionUUID="">
<personnelAction reportingOrgCode="" orgInstallID="" orgDocID="">
<adminEventIDCode></adminEventIDCode>
<adminEventStatusName></adminEventStatusName>
<changeEffDate></changeEffDate>
<correctionInd orgCorrectionDocID=""></correctionInd>
<adminEventRemarks></adminEventRemarks>
<rescindInd orgRescindDocID=""></rescindInd>
</personnelAction>
<Id></Id>
<partAcctNo></partAcctNo>
<partAcctFormerNo></partAcctFormerNo>
<orgLocalId></orgLocalId>
<orgERPId></orgERPId>
<firstName></firstName>
<middleName></middleName>
<lastName verified=""></lastName>
<birthDate verified=""></birthDate>
<deathDate></deathDate>
<gender></gender>
<nationality></nationality>
<languagePref></languagePref>
<birthCountry></birthCountry>
<maritalStatus verified=""></maritalStatus>
<partAcctEntryDate></partAcctEntryDate>
<languageAllowanceCount></languageAllowanceCount>
<employment>
<orgCode></orgCode>
<dutyStationCode></dutyStationCode>
<contract effDate="" StopDate=""></contract>
<category></category>
<grade></grade>
<step></step>
<partTimePercentage effDate="" stopDate=""></partTimePercentage>
<leaveWithoutPay effDate="" stopDate=""></leaveWithoutPay>
<secondment secondToOrgCode="" secondFromOrgCode=""></secondment>
</employment>
<familyMembers>
<familyMember>
<Id></Id>
<orgFamilyMemberId></orgFamilyMemberId>
<orgOtherParentID></orgOtherParentID>
<lastName verified=""></lastName>
<middleName></middleName>
<firstName></firstName>
<birthDate verified=""></birthDate>
<gender></gender>
<relationship></relationship>
<nationality></nationality>
<marriageDate verified=""></marriageDate>
<divorceDate verified=""></divorceDate>
<deathDate verified=""></deathDate>
<disability effDate="" verified=""></disability>
</familyMember>
</familyMembers>
</staffMember>
</Data>
<Data reportingOrgCode="" dsProcTime="" pfBatchUUID="">
<staffMember pfTransactionUUID="">
<personnelAction reportingOrgCode="" orgInstallID="" orgDocID="">
<adminEventIDCode></adminEventIDCode>
<adminEventStatusName></adminEventStatusName>
<changeEffDate></changeEffDate>
<correctionInd orgCorrectionDocID=""></correctionInd>
<adminEventRemarks></adminEventRemarks>
<rescindInd orgRescindDocID=""></rescindInd>
</personnelAction>
<Id></Id>
<partAcctNo></partAcctNo>
<partAcctFormerNo></partAcctFormerNo>
<orgLocalId></orgLocalId>
<orgERPId></orgERPId>
<firstName></firstName>
<middleName></middleName>
<lastName verified=""></lastName>
<birthDate verified=""></birthDate>
<deathDate></deathDate>
<gender></gender>
<nationality></nationality>
<languagePref></languagePref>
<birthCountry></birthCountry>
<maritalStatus verified=""></maritalStatus>
<partAcctEntryDate></partAcctEntryDate>
<languageAllowanceCount></languageAllowanceCount>
<employment>
<orgCode></orgCode>
<dutyStationCode></dutyStationCode>
<contract effDate="" StopDate=""></contract>
<category></category>
<grade></grade>
<step></step>
<partTimePercentage effDate="" stopDate=""></partTimePercentage>
<leaveWithoutPay effDate="" stopDate=""></leaveWithoutPay>
<secondment secondToOrgCode="" secondFromOrgCode=""></secondment>
</employment>
<familyMembers>
<familyMember>
<d></Id>
<orgFamilyMemberId></orgFamilyMemberId>
<orgOtherParentID></orgOtherParentID>
<lastName verified=""></lastName>
<middleName></middleName>
<firstName></firstName>
<birthDate verified=""></birthDate>
<gender></gender>
<relationship></relationship>
<nationality></nationality>
<marriageDate verified=""></marriageDate>
<divorceDate verified=""></divorceDate>
<deathDate verified=""></deathDate>
<disability effDate="" verified=""></disability>
</familyMember>
</familyMembers>
</staffMember>
<Data>


2)<Data reportingOrgCode="" dsProcTime="" pfBatchUUID="">
<staffMember pfTransactionUUID="">
<personnelAction reportingOrgCode="" orgInstallID="" orgDocID="">
<adminEventIDCode></adminEventIDCode>
<adminEventStatusName></adminEventStatusName>
<changeEffDate></changeEffDate>
<correctionInd orgCorrectionDocID=""></correctionInd>
<adminEventRemarks></adminEventRemarks>
<rescindInd orgRescindDocID=""></rescindInd>
</personnelAction>
<Id></Id>
<partAcctNo></partAcctNo>
<partAcctFormerNo></partAcctFormerNo>
<orgLocalId></orgLocalId>
<orgERPId></orgERPId>
<firstName></firstName>
<middleName></middleName>
<lastName verified=""></lastName>
<birthDate verified=""></birthDate>
<deathDate></deathDate>
<gender></gender>
<nationality></nationality>
<languagePref></languagePref>
<birthCountry></birthCountry>
<maritalStatus verified=""></maritalStatus>
<partAcctEntryDate></partAcctEntryDate>
<languageAllowanceCount></languageAllowanceCount>
<employment>
<orgCode></orgCode>
<dutyStationCode></dutyStationCode>
<contract effDate="" StopDate=""></contract>
<category></category>
<grade></grade>
<step></step>
<partTimePercentage effDate="" stopDate=""></partTimePercentage>
<leaveWithoutPay effDate="" stopDate=""></leaveWithoutPay>
<secondment secondToOrgCode="" secondFromOrgCode=""></secondment>
</employment>
<familyMembers>
<familyMember>
<Id></Id>
<orgFamilyMemberId></orgFamilyMemberId>
<orgOtherParentID></orgOtherParentID>
<lastName verified=""></lastName>
<middleName></middleName>
<firstName></firstName>
<birthDate verified=""></birthDate>
<gender></gender>
<relationship></relationship>
<nationality></nationality>
<marriageDate verified=""></marriageDate>
<divorceDate verified=""></divorceDate>
<deathDate verified=""></deathDate>
<disability effDate="" verified=""></disability>
</familyMember>
</familyMembers>
</staffMember>

<staffMember pfTransactionUUID="">
<personnelAction reportingOrgCode="" orgInstallID="" orgDocID="">
<adminEventIDCode></adminEventIDCode>
<adminEventStatusName></adminEventStatusName>
<changeEffDate></changeEffDate>
<correctionInd orgCorrectionDocID=""></correctionInd>
<adminEventRemarks></adminEventRemarks>
<rescindInd orgRescindDocID=""></rescindInd>
</personnelAction>
<Id></Id>
<partAcctNo></partAcctNo>
<partAcctFormerNo></partAcctFormerNo>
<orgLocalId></orgLocalId>
<orgERPId></orgERPId>
<firstName></firstName>
<middleName></middleName>
<lastName verified=""></lastName>
<birthDate verified=""></birthDate>
<deathDate></deathDate>
<gender></gender>
<nationality></nationality>
<languagePref></languagePref>
<birthCountry></birthCountry>
<maritalStatus verified=""></maritalStatus>
<partAcctEntryDate></partAcctEntryDate>
<languageAllowanceCount></languageAllowanceCount>
<employment>
<orgCode></orgCode>
<dutyStationCode></dutyStationCode>
<contract effDate="" StopDate=""></contract>
<category></category>
<grade></grade>
<step></step>
<partTimePercentage effDate="" stopDate=""></partTimePercentage>
<leaveWithoutPay effDate="" stopDate=""></leaveWithoutPay>
<secondment secondToOrgCode="" secondFromOrgCode=""></secondment>
</employment>
<familyMembers>
<familyMember>
<d></Id>
<orgFamilyMemberId></orgFamilyMemberId>
<orgOtherParentID></orgOtherParentID>
<lastName verified=""></lastName>
<middleName></middleName>
<firstName></firstName>
<birthDate verified=""></birthDate>
<gender></gender>
<relationship></relationship>
<nationality></nationality>
<marriageDate verified=""></marriageDate>
<divorceDate verified=""></divorceDate>
<deathDate verified=""></deathDate>
<disability effDate="" verified=""></disability>
</familyMember>
</familyMembers>
</staffMember>
<Data>

[eostic]

hard to say.

It "might" have something to do with the lack of a containment element. Try adding a "containment" element around staff member ....add "allmembers" to the xpath in the descriptions.

so...right now you have /data/staffmember ... for each column. Do a test that includes /data/allstaffmembers/staffmember... in each.

Make sure also that you have "aggregate" checked, and that you have something in the family member node checked as your single "key" that you expect will always be present (maybe lastname).

Ernie