DSXchange

I want to convert any NULL values in column XYX to "NULLXYZ" using Modify stage.

I used the following statement as specification :

XYZ:string = NullToValue(XYZ,"NULLXYZ")

But it is giving error like :

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:

aaikat wrote:I want to convert any NULL values in column XYX to "NULLXYZ" using Modify stage.

I used the following statement as specification :

XYZ:string = NullToValue(XYZ,"NULLXYZ")

But it is giving error like :

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:

Use handle_null function instead of NullToValue.

Thanks,it is solved