Page 1 of 1
Nested functions in modify
Posted: Tue Feb 24, 2009 7:13 am
by verify
Can we able to use nested functions in modify stage?
For e.g:- All the columns Xid,Yid and Zid are of same datatype.
Xid = handle_null(Zid,handle_null(Yid,Xid))
Please help me out...
Posted: Tue Feb 24, 2009 9:05 am
by DSguru2B
Have you tried it? WHat is your result?
Posted: Thu Feb 26, 2009 4:07 am
by richdhan
Hi,
You cannot have nested conditions in Modify stage. Use the transformer for this scenario.
HTH
--Rich
Posted: Thu Feb 26, 2009 4:11 am
by ray.wurlod
Nor can you have two adjacent Modify stages. You can have two (or more than two) Modify stages, but not adjacent. Place a Copy stage between them.
Posted: Fri Feb 27, 2009 5:40 am
by verify
Thanks for your inputs..
I'll go with transformer stage..