I have an issue with a date field that may contain null values. The logic to apply is:
if condition X and the date field is null then put a defined date (job parameter)
Else if Not condition X and the date field is null then put null
Else put the date field
This logic always result in the transformer dropping the records because the field contains a null.
If I simply put the following test:
Code: Select all
If IsNull(<Date Field>) Then SetNull() Else <Date Field>
So I did the following, I put the test above in a stage variable and in my derivation, I test:
If Condition X Then put defined date Else put Stage variable
This also ends up in the record being dropped.
How could I apply the correct logic while respecting DS's sensitivity about nulls?
Thanks,
Mat