Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparing 2 XML files

hi everyone,
i'm trying to compare two XML files that have the same structure. My question is: How can i do to show the difference between the two XML files. Any solutions?
Best regards.
Pegaz
Labels (3)
43 Replies
Anonymous
Not applicable
Author

Are your data sorted?
Anonymous
Not applicable
Author

Are your differents data in the same file or they might be in both file?
Anonymous
Not applicable
Author

my data are sorted, and i have 2 XML files having the same structure.
Anonymous
Not applicable
Author

I didn't find yet the solution to know the differences between the two file but I've found a solution to know the similar data.
Are you interested?
Anonymous
Not applicable
Author

For sure! thank's
Anonymous
Not applicable
Author

I did this example with two CSV file, with the same structure but with some differents values.
I've used a tUnite and after a tUniqRow.
I've used all the field as Key attribute in the tUniqRow.
As output use the Duplicates flow to see all the similar values.
However if file1 and file2 have a same row= you will see this row two times.
So I added a tAggregateRow and the groupby function in it for each field
Anonymous
Not applicable
Author

i'm trying ur example...
Anonymous
Not applicable
Author

i tried to realise a job concerning the comparaison of the 2 XML files.
Here is a screenshot of my job:

and here is the variables regarding the tFileCompare_1 settings:

Can you help me to resolve my problem, this is the error message:

Regards,
Pegaz
Anonymous
Not applicable
Author

Hi,
Why do you have specific characters in "If no differences detected, display" field.
Your error is a CodeGenerator mistake due to a bad character in your component properties.
Regards,