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 ?

 

Thanks 

Help needed please  ASAP

 

Many thanks .....

 

Forteen Stars TRF
Forteen Stars

Re: Filtering column data in the job

Hi,

tFilterRow is what you're searching for:

 

Capture.PNG

 

Hope this helps.


TRF

Tutorial

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.