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

cca8380
cca8380 Member
in Magic ETL

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.

Best Answer

  • GrantSmith
    GrantSmith Coach
    edited October 2021 Answer ✓

    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


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach

    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?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • GrantSmith
    GrantSmith Coach
    edited October 2021 Answer ✓

    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


    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories