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

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

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

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

Categories