December 27, 2006 at 10:53 am
Hello,
I am attempting to express the following condition in a Conditional Split Transformation;
[Column 0] == "D1" AND ( [Column 44] !="D" AND [Column 45] !="1")
The idea here is to have another destination for data when column 0 = D1, but only when column 44 != D and column 45 !=1.
I'm getting syntax errors when I attempt to do this. Is this kind of a condition allowed in this transformation? If so, how should the condition be expressed?
Thank you for your help!
CSDunn
December 27, 2006 at 10:57 am
I haven't tried it yet, but this might work;
[Column 0] == "D1" &&( [Column 44] !="D" &&[Column 45] !="1")
December 28, 2006 at 4:05 am
Just run a quick test and the Conditional Split does not like AND but is ok with && (Logical AND)
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply