Hi, I've been reviewing the forum on how to compare 2 files and still can't get the desired results. Here is what I'm trying to do: I have two csv files with the identical columns. The first input file has 4901 rows, the second has 4797 rows. I'm trying to compare the files and create a output file that should show the rows that are not in the second file (104) rows. I'm using the tMap and I've connected the columns of row1 to row2 and set row2 Join Model to Inner Join. On the output file I set the Catch output reject to false and the Catch lookup inner join reject to true. When I run the job, the output files contains all of the first file 4901 rows. I want it to contain the 104 rejected rows. Please help, what do I need to change? Thank you.
In your demo you use tFixedFlowInput but I don't see were I select the input file name for my CSV files? Also instead of using the tLogRow I need to send the results to a CSV output file. Can this be done? How should I proceed? Thanks
Using the example that you were given, you need two outputs. One for the inner join matches and one for the rejects (the one you're looking for). I'm also guessing that you have an outer-join not an inner join. Go back the the example you were given.
You're catching output rejects. you need to catch inner join rejects (delimited 2). As you've got nothing going to delimited 1, your join is failing for all rows which may or may not be what you're expecting.