Failed parse text 'NULL' from column 'Column Name' as type 'Date'

cca8380 · 2021-10-18T20:15:53+00:00

There was an error rendering this rich post.

cca8380

Does anyone know how I can solve for the error msg below:

I get this error msg when the ETL finds a NULL value in a column with data type 'Date'.

Thanks in advance.

Find more posts tagged with

Accepted answers

GrantSmith

Alternatively with the new ETL 2.0 you can set the data type to be a time stamp directly on the Input Dataset Tile under the Configuration tab and then click the gear icon to define how to handle bad values - in your case you can select null:

Screen Shot 2021-10-18 at 4.28.50 PM.png

All comments

GrantSmith

Can you remove the 'NULL' string in your data before it gets ingested into Domo? Are you able to ingest your data in that column as a string, use a text replace tile to replace the 'NULL' string with the actual null value then use the Set Data Type tile to convert that column to a date or date time?

GrantSmith