How to compare the two columns in a same file

[Anonymous]

Hello All

I have a scenario, that am getting a file with multiple columns, with number of rows, out of that two columns data i need to compare, that two columns data must be exactly equal for every row, how to achieve that

example for good data 

col1	col2
Open	Open
Open	Open
Open	Open

if i find That above data file is exactly valid

but if the data is in below format file is invalid , even if one row data not matched, i need to reject entire file

col1	col2
Open	Open
Open	Open
Open	not open

Can anybody suggest good method to approach this

Thanks In Advance

Manish

[TRF · Accepted solution]

Using a tMap add the following expression to the output filter:
!(""+row1.col1).equals(row1.col2)
This way, invalid records will go to the output flow. Then check how records have been rejected to decide what to do with the file.

[Anonymous]

@TRF It worked for my requirement , thanks