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

cca8380

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

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

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

Thanks in advance.

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:

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

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: