none
conditional split error RRS feed

  • Question

  • hi

    i m getting this error:

    [Conditional Split 1 [14]] Error: The expression "[Expiration Date] != [Expiration Date_LookUp] || BAC == "X" || ISNULL(BAC)" on "Conditional Split 1.Outputs[Case 1]" evaluated to NULL, but the "Conditional Split 1" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row).  The expression results must be Boolean for a Conditional Split.  A NULL expression result is an error.

    how to solve it

    Thursday, April 18, 2013 5:58 PM

Answers

  • Hi,

    I tried above expression it's working fine, if [Expiration Date] Or [Expiration Date_Lookup] is not null. If any one of it is null then you will get first error. I tried below in SQL 2012. [Expiration Date] != REPLACENULL([Expiration Date Lookup],[Expiration Date]) || BAC == "x" || ISNULL(BAC)

    It depends on your business rule.


    Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCSA (SQL 2012) , MCTS (SQL Server 2005) http://blog.vspatel.co.uk/


    • Edited by Balwant Patel Friday, April 19, 2013 8:53 AM wrote more info.
    • Marked as answer by Eileen Zhao Wednesday, April 24, 2013 7:15 AM
    Thursday, April 18, 2013 7:41 PM

All replies

  • Hi,

    Please, rewrite it as follows

    ([Expiration Date] != [Expiration Date_Lookup]) || (BAC == "X") || IsNull(BAC)


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

    Thursday, April 18, 2013 6:11 PM
  • i tried,since its not working
    Thursday, April 18, 2013 6:58 PM
  • Hi,

    I tried above expression it's working fine, if [Expiration Date] Or [Expiration Date_Lookup] is not null. If any one of it is null then you will get first error. I tried below in SQL 2012. [Expiration Date] != REPLACENULL([Expiration Date Lookup],[Expiration Date]) || BAC == "x" || ISNULL(BAC)

    It depends on your business rule.


    Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCSA (SQL 2012) , MCTS (SQL Server 2005) http://blog.vspatel.co.uk/


    • Edited by Balwant Patel Friday, April 19, 2013 8:53 AM wrote more info.
    • Marked as answer by Eileen Zhao Wednesday, April 24, 2013 7:15 AM
    Thursday, April 18, 2013 7:41 PM