When alter columns can't change column type, what else can I try?

pauljames
pauljames Contributor
in Magic ETL
image.png

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Tagged:

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    I'd look at the unique values in that column and see if there are text values there. For example, 'N/A' can't be converted to a floating decimal because it is text. The "Failed to parse text" in the error leads me to believe there are text values for that field.

    If I solved your problem, please select "yes" above

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    @pauljames

    You may need to put a filter before this alter step to filter out rows that are text before you do the alter. So you probably need to first get a list of all unique values and see if there are a lot of text values

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    I'd look at the unique values in that column and see if there are text values there. For example, 'N/A' can't be converted to a floating decimal because it is text. The "Failed to parse text" in the error leads me to believe there are text values for that field.

    If I solved your problem, please select "yes" above

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    @pauljames

    You may need to put a filter before this alter step to filter out rows that are text before you do the alter. So you probably need to first get a list of all unique values and see if there are a lot of text values

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

Categories