Change data type failing

Question & Answer
, ,
1

Hi there, I have a very large dataset. My current column is nullable dates. The format is yyyy-MM-dd. When it skips too many, it fails entirely.

image

Upon checking the errorlogs , it’s trying to cast when the value is null.

CLASS_CAST_EXCEPTION

Should it not be skipping to try to convert if the value is null? Either way it can try so it keeps a count but I require it to not fail.

2

Hi @boss
Would it be a way to keep the field as string and create a new calculated field?

Ifelse(isnull(“lastactivedate”),“1900-01-01”,“lastactivedate”)

BR

3

Agree with @ErikG that you should keep as a string during import and then write a calculated field to convert it to a date in your analysis. Can use parseDate() function to do that. You will still get nulls, but it wont result in the dataset import failing.