How do I combine two columns?

Community Support
1

Table A has two columns, one is col1, the other is col2,Reading from CSV file, the table has missing values.col1 and col2 are mutually exclusive, ie. for each row where col1 hasvalid number, col2 is “0ne”, vice versa.Now I want to combine the two columns into a new column called"total_col":I did:A: update total_col: col1 + col2 from AIt doesn’t work.because of these “0ne” 's…How do I solve this problem?Thanks a lot!

2

^

Attila