how to compare the input row from one file with all rows in the another file in talend

[psujini]

How to  compare the input file first row value with the all rows in the second input file column in talend

[vboppudi]

Hi,

Please find the job details below.

Regards,

[psujini]

Thank you so much sir ....

it helps .I will try it actually i tried the same but i didn't use the tunique row.where as it is populating all input dates in  invalid dates file.the screen shot you shared the out .in tat also the dates which are in the valid output also there in the invalid output. how could that possible?.it should not come in invalid dates output. sir would  u please check on the same..

[Anonymous]

Hello,

Here also exists a tFileCompare component which compares two files and provides comparison data based on a read-only schema.

For more information, please refer to online document about:TalendHelpCenter:tFileCompare.

Best regards

Sabrina

[psujini]

Hi Veeranjaneyulu garu,

can i have update on this sir..what i was facing issue with this.

this is giving all dates as rejected.

[psujini]

Hello sir,

The following problem is not solved!

Do you have any Idea how to catch the unparsed dates to the output.

[vboppudi]

Hi,

The job i provided has two targets one for valid dates and another one for invalid dates.

in tMap, you have two create two output groups one for valid dates and another one for invalid dates. For valid dates it will return only matched pasterns. For invalid output it will return all not matched patterns. So use tUniq after tamp for invalid output.

Regards,

[Anonymous]

Hello,

You can redirect the standard out to a file for the entire Job run by using tJava component.

And please use the following code

java.io.File file = new java.io.File("C:/temp/mytalend.log");
java.io.PrintStream log_java = new java.io.PrintStream(new java.io.FileOutputStream(file));
System.setOut(log_java);

Let us know if it works

Best regards

Sabrina

[psujini]

i didn't get this solutions.Can you please eloborate