Link to home
Create AccountLog in
Avatar of elucero
elucero

asked on

Conditional Split requires a Boolean results error

I'm getting the following error on the code below which is an expression in a conditional split.  Is there another way I can write the code to avoid the error?

((ISNULL((DT_WSTR,20)Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt) != (ISNULL((DT_WSTR,20)dest2_Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt))

"Changed" (8377)" evaluated to NULL, but the "component "Conditional Split" (473)" 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.    



--------------------------------------------------------------------------------
Avatar of knightEknight
knightEknight
Flag of United States of America image

You have this:

   ((ISNULL((DT_WSTR,20)Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt) != (ISNULL((DT_WSTR,20)dest2_Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt))


I think you mean this:

  ((ISNULL((DT_WSTR,20)Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)Personal_Stmnt_Dt) != (ISNULL((DT_WSTR,20)dest2_Personal_Stmnt_Dt) ? "" : (DT_WSTR,20)dest2_Personal_Stmnt_Dt))
ASKER CERTIFIED SOLUTION
Avatar of knightEknight
knightEknight
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
can you please explain what are you trying to do here?
we can re-write whole thing in a simple way...
maybe you need this

case
when (DT_WSTR,20)Personal_Stmnt_Dt is null then ""
when (DT_WSTR,20)dest2_Personal_Stmnt_Dt is null then (DT_WSTR,20)Personal_Stmnt_Dt
else (DT_WSTR,20)dest2_Personal_Stmnt_Dt
end