Conversion error for time stamp field in transformer stage
Posted: Thu Jan 04, 2018 1:49 pm
Hi All,
I have a few time stamp fields in transformer stage I am defaulting to Blanks ('') because I do not have source data but these fields are needed as an input for funnel operation .
Also I am converting few timestamp fields to string (vachar) using below derivation
I am getting below error with job success run
I tried to ran job with several attempts with adding /removing column by column to figure out the issue but issue still exist.
Please give me some tips on How to identify the field having the issue ?
Thanks
I have a few time stamp fields in transformer stage I am defaulting to Blanks ('') because I do not have source data but these fields are needed as an input for funnel operation .
Also I am converting few timestamp fields to string (vachar) using below derivation
Code: Select all
If IsNull(lnk_records.DATE) Then ''
Else
If IsValidTimestamp(lnk_records.DATE)
Then
DateToString(TimestampToDate(lnk_records.DATE),"%mm/%dd/%yyyy")
Else ''
Code: Select all
xfm_mapping: Conversion error calling conversion routine timestamp_from_ustring data may have been lostPlease give me some tips on How to identify the field having the issue ?
Thanks