Hello everybody!
I have following issue:
I want to test if input column1 is null, if yes I want to reject column (I do not want to have it in my output1)
I have transformer stage with 1 input and two outputs, also I have constraint defined for two outputs:
output1: IsNull(DSLink1.col1)
output2: REJECTED
also I have marked checkbox "reject row"
I don't get what I want. In output 1 I have all rows (even that in which column1 is NULL), and in output2 I have only theese rows in which column1 is NULL (that is what I want). I don't want rows with column1=NULL in output1!!
What am I doing wrong? Have you any sugestions?
regards
constraints in transformer stage
Moderators: chulett, rschirm, roy
Hi,
Usually I use:
As indication for empty or space only strings or nulls, when reading a sequential file they are the same.
Bare in mind there are times, like reading from DB, where they should be distincted and they don't mean the same thing.
this example is good when all stated options should be concidered as nulls.
IHTH,
Usually I use:
Code: Select all
Len(Trim(Link.col)) = 0
Bare in mind there are times, like reading from DB, where they should be distincted and they don't mean the same thing.
this example is good when all stated options should be concidered as nulls.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Luk,
did you remember that a constraint gets evaluated to TRUE and then sends the column out that stream.
Meaning that if the constraint reads "ISNULL(In.Column)" then only nulls columns are passed, and the REJECT merely takes any rows that haven't gone down any previous links.
Looking at your logic and reading your text I think you have the functionality inverted.
did you remember that a constraint gets evaluated to TRUE and then sends the column out that stream.
Meaning that if the constraint reads "ISNULL(In.Column)" then only nulls columns are passed, and the REJECT merely takes any rows that haven't gone down any previous links.
Looking at your logic and reading your text I think you have the functionality inverted.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: