Null Handling using Modify stage

[rajeev_prabhuat]

Hi,

I am reading data from a sequentile file, with fields with two null colunms and one notnull column, to handle the null vaules i used Modify stage and in the specifications of the Modifystage i gave the expression as follows:

col_1= NullToValue (col_1,'AA')
col_2 = NullToValue (col_2,0)

When i complie it is fine, but when i validate it i am getting the error. The error is as follows:

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:
col_1= NullToValue (col_1,AA)
;
col_2 = NullToValue (col_2,0)

Can anyone guide me, to solve this problem.

Regards,
Rajeev Prabhu

[roy]

Hi,
use search here befor you post so we have less duplicate posts of the same data.
by the way using search prevented me from posting this exact question!

IHTH

[Amos.Rosmarin]

use this syntax:

ENTITY_TYPE=handle_null(ENTITY_TYPE,"NO_TYPE")


Amos

[T42]

Do a search for "Orchestrate" or "Modify" and "Null"