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

 

1 REPLY
Twelve Stars TRF
Twelve Stars

Re: Filtering column data in the job

Hi,

tFilterRow is what you're searching for:

 

Capture.PNG

 

Hope this helps.


TRF