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:
NULL Handling using Modify stage
Moderators: chulett, rschirm, roy
Re: NULL Handling using Modify stage
Use handle_null function instead of NullToValue.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: