Filtering column data in the job

Five Stars ami
Five Stars

Filtering column data in the job

Dear Users,


I have one small requirement , i want to filter out data from one column  called as failure" 

There are values like 1 , 0 and -150 in failure column but i want only 0 to go  further and want to stop 1 and -150 


The failure column data type in our staging table is string 


can you please help with code ?

 and where in tmap i have to write a code ?



Help needed please  ASAP


Many thanks .....


Forteen Stars TRF
Forteen Stars

Re: Filtering column data in the job


tFilterRow is what you're searching for:




Hope this helps.



Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.