Convert Column Type: ETL or SQL

Lara
Lara Member

Hi,

 

I have a column that contains letters from a to k and also numbers. 

I would like to replace the letter with 0 and change the column type from text to numbers.

While doing this on ETL the run fails.

 

The way I did it was: 

1- replace text and enter each letter to be replace by 0

2-set column type

I don't understand why I am getting the error! is there a better way to do this?

Thanks!

Comments

  • Could you describe the ETL or post a screenshot? Do you know for certain that this is where the ETL is failing? I am wondering if the failure is happening farther downt he line in the ETL.

  • Lara
    Lara Member

    I don't have it anymore , I ended up wirting it in SQL to change the values and then use Beast Mode Sum('Column Name') it worked well.

     

    Thank you ?