There is a simple derivation where a source date column which is Nullable is to be replaced with NOT NULL date column when the source column is NULL.
Tried the below:
Code: Select all
TST=handle_null(KEY2,KEY1)
Result when all KEY2 are NULL
abc,KEY1
abc,KEY1
abc,KEY1
And I dont want to use a transformer with If then else clause for such simple thing. Any ideas
Thanks