remove records based upon constraint

times29 · Post by **times29** » Fri Jan 20, 2012 2:41 am

Hi,
I am trying to remove records from incoming stream in transformer
doing below code as i don't want Agent as output and its not working

(to_transf.STATUS= 'Agent')<>0

MT · Post by MT » Fri Jan 20, 2012 2:52 am

Hi times29

well just look at you logic:
1. you compare if the STATUS field equals AGENT
2. The result shoul not be zero

If you do just number 1, it will work - your logic is kind of doubled this is producing the error

nayanpatra · Post by **nayanpatra** » Fri Jan 20, 2012 2:57 am

Please try the below logic

Trim(to_transf.STATUS) <> 'Agent'

to restrict the incoming records.

times29 · Post by **times29** » Fri Jan 20, 2012 6:48 am

Well i tried Trim(to_transf.STATUS) <> 'Agent' too its not working

qt_ky · Post by **qt_ky** » Fri Jan 20, 2012 7:43 am

Show some actual values from the status column and also tell the data type of the status column.

qt_ky · Post by **qt_ky** » Tue Jan 24, 2012 8:10 pm

Make sure you put that into the constraint and not into an output column derivation. Confirm you have tested that. Otherwise give more details/actual error message.

SURA · Post by **SURA** » Tue Jan 24, 2012 11:41 pm

On top of that Try

Trim(UpCase(to_transf.STATUS)) <> 'AGENT'

DS User

DSXchange

remove records based upon constraint

remove records based upon constraint

Re: remove records based upon constraint