topic Re: Comparing 2 XML files in Talend Studio

Comparing 2 XML files

Anonymous — Sat, 16 Nov 2024 14:26:30 GMT

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

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 15:52:56 GMT

Are your data sorted?

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 16:00:38 GMT

Are your differents data in the same file or they might be in both file?

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 16:11:17 GMT

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

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 16:36:24 GMT

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?

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 16:52:23 GMT

For sure! thank's

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 16:59:43 GMT

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

Re: Comparing 2 XML files

Anonymous — Wed, 05 Mar 2008 17:15:03 GMT

i'm trying ur example...

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:01:53 GMT

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

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:12:27 GMT

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,

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:21:34 GMT

Doesn't change anything when i delete specific characters

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:30:32 GMT

Hi,
If you switch your designer tab to code tab, you will see the line in the codeGenerator with the compilation error.
Can you send a screenshot or a copy/paste of this area, please.
Regards;

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:33:34 GMT

you can try with two tfile list.
In each tFilelist you specified the directory and the name file
After you can use ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) & ((String)globalMap.get("tFileList_2_CURRENT_FILEPATH"))

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 10:47:14 GMT

Hi,
In your case, you need Iterate only on one Folder to compare with one reference file.
Can you try this, remove tFileList2 component ?
You can find further information in our User Guide.
Regards;

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:17:12 GMT

my tfilecompare_1 output contains the default parameters(file, file_ref,moment,...) . I can't change it !
is it possible to change the output?

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:20:26 GMT

what do you want in your output?

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:22:36 GMT

i want to show as an output my own columns related to my project

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:24:40 GMT

your own columns? What do you mean? You want to choose only some few columns from the tFileCompare or the row of each file?

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:31:50 GMT

yes, only some few columns from the tFileCompare

Re: Comparing 2 XML files

Anonymous — Fri, 07 Mar 2008 11:34:31 GMT

you can use a tMap