Filtering column data in the job

Anonymous — Tue, 24 Oct 2017 09:12:40 GMT

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

Re: Filtering column data in the job

TRF — Tue, 24 Oct 2017 09:36:42 GMT

Hi,

tFilterRow is what you're searching for:

Hope this helps.