Modify Stage handling NULL replacing with another column

samarvind · Post by **samarvind** » Thu Jun 05, 2014 4:30 am

Hi,

I am trying to use the Modify Stage to handle Null for one of the column by replacing with value from another input column. Is it possible ?

Specification that I have tried but didn't work looks similar to the one below.

Ex. COL2 = handle_null (COL2,COL1)

Thanks
Arvind

ray.wurlod · Post by **ray.wurlod** » Thu Jun 05, 2014 4:15 pm

I'm pretty sure that the second argument to handle_null() must be a constant.

As a more general rule Modify stage functions can only operate on one input field.

samarvind · Post by **samarvind** » Fri Jun 06, 2014 2:40 am

Thanks Ray, I thought so. Only reason I wanted to see if this functionality can be achieved in Modfiy stage is that I wanted to reduce the usage of transformer wherever possible but given the scenario I might have to use one I think.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 06, 2014 5:57 am

samarvind wrote:I wanted to reduce the usage of transformer wherever possible.

Why?

chulett · Post by **chulett** » Fri Jun 06, 2014 6:45 am

Transformerphobia is overrated.