Hi
Can any one please tell me how do I give multiple conditions in Conditional Split Transformation.
Exp:
I have few columns as
ReturnSUK
TimeSUK
EntitySUK
PeriodSUK
Now the condition should be :
! ISNULL (ReturnSUK) & ! ISNULL (TimeSUK) & ! ISNULL (EntitySUK) &! ISNULL (PeriodSUK)
Please provide me the proper condition for the above mentioned requirement.
Thank you
Use two & symbols:!ISNULL(ReturnSUK) && !ISNULL(TimeSUK) && ....|||
Thank you Its Working
If i need to give the same condition for OR (^) rather then AND (&) so the condition would be
this :
ISNULL(ReturnSUK) ^ ISNULL(TimeSUK) ^ ISNULL(BankSUK) ^ ISNULL(EntitySUK) ^ ISNULL(PeriodSUK)
or ,can you please help me in this too.
Thank you
|||Or is written by using two || symbols:TEST1 || TEST2 || TEST3 ....
No comments:
Post a Comment