Convert Column Type: ETL or SQL

Lara Member



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?



  • KVincent

    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 ?