topic Re: How to compare the two columns in a same file in Talend Studio

How to compare the two columns in a same file

Anonymous — Sat, 16 Nov 2024 04:26:26 GMT

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

Re: How to compare the two columns in a same file

TRF — Tue, 08 Oct 2019 15:10:38 GMT

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.

Re: How to compare the two columns in a same file

Anonymous — Tue, 08 Oct 2019 16:05:39 GMT

@TRF It worked for my requirement , thanks