constraints in transformer stage
Posted: Wed Aug 17, 2005 3:47 am
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
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