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.
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:
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?