Dataflow failed

A2024
A2024 Member
edited August 2023 in Magic ETL

Hello all,

I get the below error after running my dataflow. As this consists for multiple inputs, I haven't still been able to trace the exact field causing it. But I do have a formula tile with this calculation..

" Failed to convert value '-3--3-01' from type 'String' to type 'Date'. "

Some days this data flow runs successfully with no issues. Once in a while this fails with this error. So trying to understand how to avoid this to fail occasionally.

Appreciate your help!

image.png

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can wrap your beast mode in an IFERROR function to default it to another value if there was an error with your date conversion

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can wrap your beast mode in an IFERROR function to default it to another value if there was an error with your date conversion

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

    Thank you @GrantSmith for immediate response. I will try this and let you know.

  • A2024
    A2024 Member

    Awesome! This worked @GrantSmith ! Thank you for saving my time. Much appreciated!

Categories