Getting rows with differences between two data tables

[JABELLA1634831127]

Hi so I currently have this tmap which gets all rows with differences between two tables. The problem is it also gets additional rows in the first table that is not in the second table. How can I get only rows with differences not including rows present in data table 1 but not present in data table 2.

[JABELLA1634831127]

 

Would this be correct?

[gjeremy1617088143]

no :

first send tfileinputexcel6 to a hash,

then onsubjobok link,

you read your main file you join with a hash (with tJoin) and the output of this is joined to a second hash in a tMap (both HashInput a relied to the same hashInput, on the second one you check the checkbox for deleting the hash after reading the data)

[gjeremy1617088143]

something like this :

[JABELLA1634831127]

Hi really sorry I'm asking so much but how should my tmap look like. I followed the picture above but I think my tmap is wrong, since im getting null values in all my rows.

[gjeremy1617088143]

you have to set row8 instead of row9 in the ouptut schema

[JABELLA1634831127]

thanks for all your help. it works now 🙂

[gjeremy1617088143]

don't forget to select one of my answer as the best and merry Christmas