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 :
Look Up input :
And my output came out as below:
|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"
I am attaching he mapping and tmap settings.
I have created two variables with string datatype
Let me know if it worked.
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.