Forum Discussion
Helper IExtracting text and numerical types from one column and splitting into two columns
After trying all the methods the most workable solution was as follows:
1. Duplicate the column you want to split
2. Change the duplicated column to a numerical type column
3. Replace any errors with nulls
4. Create a conditional column that states where the numerical type column is 'null' then take the value from the original column.
Helper IAfter trying all the methods the most workable solution was as follows:
1. Duplicate the column you want to split
2. Change the duplicated column to a numerical type column
3. Replace any errors with nulls
4. Create a conditional column that states where the numerical type column is 'null' then take the value from the original column.
- AlexisOlson
Super User
Just FYI, this is nearly the same as what I suggested except that I did the equivalent of 1,2,3 as single step, #"Added Numerical Column".
