Filtering column data in the job

[Anonymous]

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 .....

[TRF]

Hi,

tFilterRow is what you're searching for:

Hope this helps.