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

[hami1]

Hello,

For this scenario you need to Iterate 1-Input File and Compare this value with the another input Flow.

In First flow take tFileInputDelimitted , tFlowToIterate , then connect iterate to tMap component. In Second flow take another tFileInputDelimitted component and lookup this to tMap Component. In join Condition perform a Join operation.

Thanks,

Hameed

                                                                                                                         |

[psujini]

Hi Thank you so much fo ryour quick reply on this , but i cannot able to connect the tFlowToIterate , then connect iterate to tMap component.

Please help.Actually my task is

i have a input file with  date column having different  formats which is unknow to the user in which format is  and  another file is having all possible  different date formats. i need to compare the inpute date with all possble date formats in the another file .

for that am using the logic TalendDate.isDate(row1.line,row2.date)?TalendDate.parseDate(row2.date,row1.line): 

where row1.line is my input date row2.date is my date format in the another file.if matches then parse the string date . to sample date format.

would you please tell the Job flow

[hami1]

It would be great if you can provide me some sample data, So that I can explain you perfectly. If am not wrong you wants to check whether the Incoming date_format is a valid date format or not by comparing this with some predefined date_formats. Otherwise you need to reject the record.

Thanks

[psujini]

Yes it is same u expected.but 

I am attaching the  input_date file and date _pattern file please provde me the flow

Files.zip

[psujini]

Can anyone help on this

[vboppudi]

Hi,

What are you trying to do here?

Are you validating input date value is in any of specified for or not?

Regards,

[vboppudi · Accepted solution]

Hi,

Please try the below approach to join two files in tMap with join condition. in second tMap use TalendDate.isDate(Date,date_pattern,true) .

Regards,

[psujini]

Thank you so much...I did the same....can u please share the screen shots
of the 2 tmaps

[vboppudi]

Please find the below screens

Regards,