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
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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].
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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