Failed to run dataset due to error from the bery beginning node

Thuy_Tu
Thuy_Tu Member
in Magic ETL

I have a dataset that failed to run due to an error from the very beginning node. It said "Failed to convert value '5785586.012810127' from type 'String' to type 'Date'."

Screenshot 2025-02-17 at 9.28.32 AM.png

However, that input itself runs normally and the data looks legit. I checked, no abnormal and no value of 5785586 anywhere.

I tried to change all timestamp to date but it still faces the error.

Can you please advise on how to fix this? Thanks!

Tagged:

Best Answer

  • ggenovese
    ggenovese Coach
    Answer ✓

    If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.

Answers

  • ggenovese
    ggenovese Coach
    Answer ✓

    If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.

  • Thuy_Tu
    Thuy_Tu Member

    Thanks so much! That helps big time.

Categories