DSXchange

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

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

use this syntax:

ENTITY_TYPE=handle_null(ENTITY_TYPE,"NO_TYPE")


Amos

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