I have a task where I have a complex set of repeating elements that are expected in the XML message going to MQ. I have been trying for 2 days now but I am seeing that for the complex repeating elements, the value is automatically getting deduped - grouoped even though the trigger column is something else.
For e.g.
The input records are: -
Code: Select all
Row1 PartyID: 123456789, prevRR: H, CuRR: H, Hierarchy: TK, H1party: L063969385, H1RR: S, H1Ind: N
Row2 PartyID: 26789456, prevRR: H, CuRR: H, Hierarchy: TK, H1party: L063969385, H1RR: S, H1Ind: N
Row2 PartyID: 987654321, prevRR: H, CuRR: H, Hierarchy: TK, H1party: L063969385, H1RR: S, H1Ind: N
: -
Code: Select all
<ns1:OR>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>123456789</ns2:PartyId>
</ns1:ORParty>
<ns1:ORPreviousRR>H</ns1:ORPreviousRR>
<ns1:ORCurrentRR>H</ns1:ORCurrentRR>
<ns1:ORHierarchy>TK</ns1:ORHierarchy>
</ns1:OR>
<ns1:OR>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>26789456</ns2:PartyId>
</ns1:ORParty>
<ns1:ORPreviousRR>H</ns1:ORPreviousRR>
<ns1:ORCurrentRR>H</ns1:ORCurrentRR>
<ns1:ORHierarchy>TK</ns1:ORHierarchy>
</ns1:OR>
<ns1:OR>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>987654321</ns2:PartyId>
</ns1:ORParty>
<ns1:ORPreviousRR>H</ns1:ORPreviousRR>
<ns1:ORCurrentRR>H</ns1:ORCurrentRR>
<ns1:ORHierarchy>TK</ns1:ORHierarchy>
</ns1:OR>
<ns1:H1>
<ns1:H1Party TransactionType="C">
<ns2:PartyIdTypeCode>ProfileId</ns2:PartyIdTypeCode>
<ns2:PartyId>L063969385</ns2:PartyId>
</ns1:H1Party>
<ns1:H1ChannelCd>19</ns1:H1ChannelCd>
<ns1:H1RR>S</ns1:H1RR>
<ns1:H1ProfileDate>2015-06-12</ns1:H1ProfileDate>
<ns1:H1Ind>N</ns1:H1Ind>
</ns1:H1>
However when I see the payload, I am getting it as: -
Code: Select all
<ns1:OR>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>123456789</ns2:PartyId>
</ns1:ORParty>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>26789456</ns2:PartyId>
</ns1:ORParty>
<ns1:ORParty TransactionType="C">
<ns2:PartyIdTypeCode>PTY_ID</ns2:PartyIdTypeCode>
<ns2:PartyId>987654321</ns2:PartyId>
</ns1:ORParty>
<ns1:ORPreviousRR>H</ns1:ORPreviousRR>
<ns1:ORCurrentRR>H</ns1:ORCurrentRR>
<ns1:ORHierarchy>TK</ns1:ORHierarchy>
</ns1:OR>
<ns1:H1>
<ns1:H1Party TransactionType="C">
<ns2:PartyIdTypeCode>ProfileId</ns2:PartyIdTypeCode>
<ns2:PartyId>L063969385</ns2:PartyId>
</ns1:H1Party>
<ns1:H1ChannelCd>19</ns1:H1ChannelCd>
<ns1:H1RR>S</ns1:H1RR>
<ns1:H1ProfileDate>2015-06-12</ns1:H1ProfileDate>
<ns1:H1Ind>N</ns1:H1Ind>
</ns1:H1>