ok so it exists a solution with a tMap but it's quite heavy...
You can use the tmap if you are sure that your id won't change at any moment.

You use a filter :
for the first flow :

!row1.first_name.equals( row2.first_name)

for the second :

!row1.last_name.equals(row2.last_name )

After you can set your output fields to :

first:
"issue in id  "+row1.id+" : "+row1.first_name+" different to "+row2.first_name

second:
"issue in line  "+row1.id+" : "+row1.last_name+" different to "+row2.last_name

Last edited by cahsohtoa (2008-03-13 16:50:26)

of course, I use 2 csv files a two output

check the format of your output field it must be a string

i have this as an output:

Starting job projet at 18:10 13/03/2008.
NumberFormatException For input string: ""id"
NumberFormatException For input string: ""1"
NumberFormatException For input string: ""id"
NumberFormatException For input string: ""1"
Job projet ended at 18:10 13/03/2008. [exit code=0]

ok

all right see you toomorow

ok I will have a look

i resolved my problem some wrong paramters... i fixed them and it's ok now!

Hello,

Someone can help me to solve my problem?

We suppose that we have 2 xml files: file1.xml and file2.xml. Both of files have the same structure.


file1.xml:                                   |           file2.xml:
                                                |
id= 1                                         |          id= 1
first_name= MACKLEY                |           first_name=ROBINSON
last_name= bob                         |           last_name=david
                        |
                        |       id= 2
                        |           first_name=BROWN
                        |           last_name=Jenny

I need to identify the id of the added line in file2.xml and then to show the first_name and last_name.

Something like this:
id =2  | first_name=BROWN | last_name=Jenny



Regards.

Last edited by pegaz (2008-03-25 16:42:09)