Null handling on timestamp fied in modifystage

[reddy12]

how can i handle null on timestamp in modify stage?
in specification properties what can i write? give suggestion.

Thanks

[diamondabhi]

Again search would be a good thing to do:

(from another post): One way nulls can be handled is

When you have this problem of dates being null and you wish to use them in routines or stage variables, it can be usefull if you have a 'special date' that is outside of the domain of your data, i.e. 9999-12-31, which you can use set null dates to using

Code:
NullToValue(input.date, StringToTimestamp('9999-12-31 00:00:00', '%yyyy-%mm-%dd %hh:%nn:%ss'))

[DSguru2B]

A small correction here. NullToValue() will work only in the transformer stage. It wont in the modify stage. There is a mistake in the parallel guide. Use handle_null(). Search on the name for its exact syntax.

[reddy12]

Thanks for your response DSguru2B

Can you please give me one example?
I am getting problem with that.
DATEFIELD=handle_null()
what can i specify in () ?

A small correction here. NullToValue() will work only in the transformer stage. It wont in the modify stage. There is a mistake in the parallel guide. Use handle_null(). Search on the name for its exact syntax.

[us1aslam1us]

It will be same as the NullToValue.

Code: Select all

DateFiled=handle_null(FieldName, "NULL")

IHTH

[reddy12]

I specified in properties like below
specification=DATE = handle_null(DATE," ")

I am getting the below Error.

Modify_14: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "DATE" to field "DATE": Bad literal for type timestamp: .

Please help me

It will be same as the NullToValue.

Code: Select all

DateFiled=handle_null(FieldName, "NULL")

IHTH

[us1aslam1us]

Check your other post...

[reddy12]

I checked.Thank you very much for your quick response.

Check your other post...