February 23, 2015 at 2:21 am
Hi,
Can someone explained how the conditional split is doing as not sure what it is doing?
ISNULL(KeyRef) ? FALSE : (KeyRef == "*CORRECT*" ? FALSE : (KeyRef == "***FAILED***" ? FALSE : (KeyRef == "" ? FALSE : @[User::CreateDesign])))
Thanks
February 23, 2015 at 2:36 am
A quick reformat may help
ISNULL(KeyRef) ? FALSE :
(KeyRef == "*CORRECT*" ? FALSE :
(KeyRef == "***FAILED***" ? FALSE :
(KeyRef == "" ? FALSE :
@[User::CreateDesign])))
If KeyRef is null, return false, else
If KeyRef = "*CORRECT*" return false, else
... and so on
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 23, 2015 at 2:40 am
So am I right in saying if the field KeyRef is not one of the followings:
NULL
*CORRECT*
***FAILED***
'' (Empty)
Then it does not meet the condition so It will not get passed to the the next step of the package?
February 23, 2015 at 3:03 am
SQL_Kills (2/23/2015)
So am I right in saying if the field KeyRef is not one of the followings:NULL
*CORRECT*
***FAILED***
'' (Empty)
Then it does not meet the condition so It will not get passed to the the next step of the package?
No that's not right.
If KeyRef is any of NULL, *CORRECT*, ***FAILED***, '' (Empty), the data will not get passed down that particular output.
If KeyRef is not any of NULL, *CORRECT*, ***FAILED***, '' (Empty), whether the data gets passed down that output depends on the value of @[User::CreateDesign].
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 23, 2015 at 5:29 am
Thanks for your help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply