Conditional Split Expression

• GBeezy

  SSCarpal Tunnel

  Points: 4723

  More actions

  February 13, 2014 at 11:30 am

  #282420

  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!!!

• Lempster

  SSCoach

  Points: 15651

  More actions

  February 14, 2014 at 4:21 am

  #1689018

  Just change your expression to [InvalidAreaCode]== "Invalid Area Code" || ISNULL([InvalidAreaCode])

  Regards

  Lempster