Identify if the repeating list is duplicate only if certain elements are same
Hi ,
The input xml contains a list "lineitems". I want to identify if there any duplicate elements in the lineitems list. The key for the unique element is a combination of 3 elements ,
<EmpNumber>
<dataSource>
<lineOfBusiness>
Input XML
<Root>
<totalAmount>10.00</totalAmount>
<sourcePhoneNumber/>
<lineItems>
<lineItem>
<sequenceNumber>1</sequenceNumber>
<amount>10.00</amount>
<amountFor>10.00</amountFor>
<isCashSweep>false</isCashSweep>
<EmpInfo>
<EmpNumber>138394</EmpNumber>
<dataSource>DEF</dataSource>
<lineOfBusiness>PC</lineOfBusiness>
<type>PA</type>
<zipCode>95136</zipCode>
</EmpInfo>
<lineItemExtension/>
</lineItem>
<lineItemsExtension/>
</lineItems>
<lineItems>
<lineItem>
<sequenceNumber>1</sequenceNumber>
<amount>10.00</amount>
<amountFor>10.00</amountFor>
<isCashSweep>false</isCashSweep>k
<EmpInfo>
<EmpNumber>227314</EmpNumber>
<dataSource>ABC</dataSource>
<lineOfBusiness>PC</lineOfBusiness>
<type>PA</type>
<zipCode>95136</zipCode>
</EmpInfo>
<lineItemExtension/>
</lineItem>
<lineItemsExtension/>
</lineItems>
<lineItems>
<lineItem>
<sequenceNumber>1</sequenceNumber>
<amount>10.00</amount>
<amountFor>10.00</amountFor>
<isCashSweep>false</isCashSweep>k
<EmpInfo>
<EmpNumber>227314</EmpNumber>
<dataSource>ABC</dataSource>
<lineOfBusiness>PC</lineOfBusiness>
<type>PA</type>
<zipCode>95136</zipCode>
</EmpInfo>
<lineItemExtension/>
</lineItem>
<lineItemsExtension/>
</lineItems>
</Root>
Expected Output
Returns True or the duplicate nodeset if the lineitems list contains same values for elements
<EmpNumber>,<dataSource>,<lineOfBusiness> .
Regards,
Arun
|