Ask a Question
Log In / Sign Up
Resources
Ask a Question
Log In Sign Up

How to compare a node value in one xml to similar nodes in another xml

SOLVED
Solved
AA26
New Contributor
‎09-04-2019 12:04 PM
‎09-04-2019 12:04 PM

How to compare a node value in one xml to similar nodes in another xml

I have 2 XMLs and need to compare the node values.

example:

XML1 has 4 firstname and 4 last name node and same with XML2 but both are not in same order.

I need to make sure that all the 4 names in XML1 match with all 4 in XML2 ( if not first element then looping through remining)

I have tried getNodeValues and am getting the values but not sure on comaparing them. 

Can someone please help me as am new to groovy and this is very confusing for me

0 Kudos
4 REPLIES 4
nmrao
Community Hero
Community Hero
‎09-04-2019 10:06 PM
‎09-04-2019 10:06 PM

Please add sample xmls and specify which data to be compared. That would help to understand easily. Need not be exact data, but same structure.


Regards,
Rao.
0 Kudos
AA26
New Contributor
In response to nmrao
‎09-05-2019 07:46 AM
‎09-05-2019 07:46 AM

xml1 and xml 2 same format

<body>

<service>

<fill>

<response>

<DR>

   <Inc> 

    <desc>abc</desc>

    <date>111 </date>

  <inc>

 <Inc> 

    <desc>def</desc>

    <date>222</date>

  <inc>

<DR>

<response>

<fill>

<service>

<body>

 

now I need to take the values for xml1 (desc and date combination from inc ) and compare it to all same fields in xml 2. abc-111 combination on xml1 is the first inc of the xml1 but it need not be the first in the xml2. 

similarly I can have multiple Inc in one xml and need to compare all of them to match on  the second and provide pass whenever it matches. if it matches on the first -first combination, then I need to start searching for second Inc on xml 2. if this is not in second place on xml2, I need to search all the remainiung Inc

The desc can be repaeating for multiple Inc

 

 

0 Kudos
nmrao
Community Hero
Community Hero
In response to AA26
‎09-05-2019 10:32 PM
‎09-05-2019 10:32 PM

Create a sorted list for each <inc> by <desc> element; and each element in the should be a map which contains <desc>, <date> and their values as key, value pairs. Do the same for xml2. Then compare both the lists.
Should come something like:
xml1 = [ [desc: 'abc', date: '111'], [desc: 'def', date:'222']]
xml2 should also be same.


Regards,
Rao.
0 Kudos
Olga_T
SmartBear Alumni (Retired)
SmartBear Alumni (Retired)
In response to nmrao
‎09-10-2019 04:49 AM
‎09-10-2019 04:49 AM

Thank you for the suggestion, @nmrao.

 

@AA26, is this what you were looking for?


Olga Terentieva
SmartBear Assistant Community Manager

0 Kudos
Subscribe
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: