Nested functions in modify

verify · Post by **verify** » Tue Feb 24, 2009 7:13 am

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...

DSguru2B · Post by **DSguru2B** » Tue Feb 24, 2009 9:05 am

Have you tried it? WHat is your result?

richdhan · Post by **richdhan** » Thu Feb 26, 2009 4:07 am

Hi,

You cannot have nested conditions in Modify stage. Use the transformer for this scenario.

HTH
--Rich

ray.wurlod · Post by **ray.wurlod** » Thu Feb 26, 2009 4:11 am

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.

verify · Post by **verify** » Fri Feb 27, 2009 5:40 am

Thanks for your inputs..

I'll go with transformer stage..