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 lost
Please give me some tips on How to identify the field having the issue ?
Thanks