Hi
below id the code for one of my coulumn in modify stage
COL:timestamp=TimestampFromSecondsSince(COL)
converting integer to timestamp
is it correct???
as i am getting the following Fatal error
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: TimestampFromSecondsSince
Expected destination field selector, got: ")"; input:
COL:timestamp=TimestampFromSecondsSince(COL)
and Job aborts
Thanks
Modify Stage
Moderators: chulett, rschirm, roy
Hi deepak,
i used the following derivation
COLumn:timestamp=Timestamp_From_Seconds_Since(COLumn)
but still i am getting the error
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
i used the following derivation
COLumn:timestamp=Timestamp_From_Seconds_Since(COLumn)
but still i am getting the error
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
Thank
eze
eze
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am Using the following code in the specification
COLUMN:timestamp=timestamp_from_seconds_since(COLUMN)
Error what i get is:
"""""
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;
"""""
COLUMN:timestamp=timestamp_from_seconds_since(COLUMN)
Error what i get is:
"""""
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;
"""""
Thank
eze
eze
I have date comming from source, i want to take the min and max for date
i am changing the timestamp to secondssincefromtimestamp in the transformer then taking it into aggregator do min / max then take it to modify stage where iam using the following specification to chane it back to timestamp
COL:timestamp=timestamp_from_seconds_since(COl)
i am getting the following error
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;
please suggest
i am changing the timestamp to secondssincefromtimestamp in the transformer then taking it into aggregator do min / max then take it to modify stage where iam using the following specification to chane it back to timestamp
COL:timestamp=timestamp_from_seconds_since(COl)
i am getting the following error
main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[*******************](dfloat)": APT_Conversion_TimeStamp_SecondsSince: Parameter [] does not parse as a timestamp
Expected destination field selector, got: ")"; input:
TABLE_LOAD_END_DT:timestamp=timestamp_from_seconds_since(TABLE_LOAD_END_DT)
;
please suggest
Thank
eze
eze