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

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?

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= [a,a] you will see this row two times.

So I added a tAggregateRow and the groupby function in it for each field

Last edited by cahsohtoa (2008-03-05 18:00:52)

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

Last edited by pegaz (2008-03-07 11:09:04)

Doesn't change anything when i delete specific characters

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"))

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

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

yes, only some few columns from the tFileCompare

hello,

I need to compare 2 XML files. Actually, I can do this, show if the files differ or not and how many lines do they differ.
My question is: How can i identify which row do they differ and what is the id. Let's consider this example:

xml1:                                                   xml2:
id= 12                                                  id= 12
first_name= MACKLEY                           first_name= MACKLEY
last_name= bob                                    last_name= david


I want to see as a result: the 2 XML files differ/ they differ on: last_name / the id= 12

Regards.

Pegaz

i'm trying to switch to an other solution using tmap.

tFileInputXML_1--------->
                                              tMap_1---------->  tLogRow_1
tFileInputXML_2--------->

any suggestions?

thank's

no, only 2 fields at this moment.