Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Conditional Split Expression Expand / Collapse
Author
Message
Posted Thursday, February 13, 2014 11:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:18 AM
Points: 116, Visits: 519
I am attempting to write an expression for a conditional split. The Column name is InvalidAreaCode and the values of the column will always either be NULL or Invalid Area Code. Right now the expression looks like:

[InvalidAreaCode] == "Invalid Area Code"

When one of the NULL values is evaluated, it fails with "output "Bad Number" (127)" evaluated to NULL, but the "component "CSPLT - Split our bad Phone Numbers from Legit Numbers" (95)" requires a Boolean results.

I see NULL Functions within the CSPLT, but I cant get it to work correctly.

Any help will be greatly appreciated!!!
Post #1541352
Posted Friday, February 14, 2014 4:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 2,036, Visits: 1,378
Just change your expression to
[InvalidAreaCode]== "Invalid Area Code" || ISNULL([InvalidAreaCode])

Regards
Lempster
Post #1541537
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse