topic Re: Unable to compare columns in two excels using Tmap in Talend Studio

Unable to compare columns in two excels using Tmap

Anonymous — Wed, 11 Jul 2018 11:40:08 GMT

Hello Team,

I m trying to compare data in two excels using Tmap and create a excel output which will have all the records that dont match.My excel data has an ID column and few other columns like Age, Gender, Address, etc. I am able to compare the excels and pin point which ID has mismatches. But unable to identify the column having differences. I tried using the Tmap expression, and the test button there gives me correct result, but final data is not showing proper.

This was my excel input :

id	Age	Gender
123	25	Female

Look Up input :

id	Age	Gender
123	24	Female

And my output came out as below:

id	Age	Gender
123	Not Equal	Not Equal

Gender being same gave me 'Not Equal'

I gave my tmap expression as :

row1.Age == row2.Age , but didnt work. Tired converting to string as below. But that too failed.

String.valueOf(row1.Age) .equals(String.valueOf(row2.Age)) ? "Equal" : "Not Equal"

Please help!

Re: Unable to compare columns in two excels using Tmap

Anonymous — Wed, 11 Jul 2018 12:09:07 GMT

Hi,

Along with id join age as key column and try inner join.To catch the reject set inner join reject true.

Re: Unable to compare columns in two excels using Tmap

Anonymous — Wed, 11 Jul 2018 13:00:55 GMT

Hi Priya,

I am attaching he mapping and tmap settings.

I have created two variables with string datatype

row2.age.equals(row2.age)?"Equal":"Not Equal"

row1.gender.equals(row2.gender)?"Equal":"Not Equal"

Let me know if it worked.

equal_mapp.PNG
tmap_match.PNG

Re: Unable to compare columns in two excels using Tmap

Anonymous — Wed, 11 Jul 2018 13:26:14 GMT

I Have given inner join true to get the rejected records.

And have attempted the same settings, but still throwing me a 'Not Equal' result.

Re: Unable to compare columns in two excels using Tmap

Anonymous — Wed, 11 Jul 2018 14:43:31 GMT

hi priyajr,

dont check ineer join on all the columns.just do on ID column.

Re: Unable to compare columns in two excels using Tmap

Anonymous — Thu, 12 Jul 2018 07:21:57 GMT

Hi Aaryan,

I had tried that as well, but in that case i m not getting the rejected records in my file.