Skip to Content
0
Jul 19, 2016 at 10:50 PM

Convert varchar column to numeric (int or decimal)

353 Views

Hello,

By uploading a big flat file (1.5 GB) into HANA the columns are only recognized as varchar and I don’t have the possibility to change the data type.

I've already tried this: creating a table with the correct type (currencies as decimal (17,2) and quantities as decimal (17,2). But by uploading the table, the mapping doesn’t work. The error message said that I could not map from varchar to decimal. I tried with all numeric data type and it’s not working.

The problem is that the table is quite big. I cannot open it in excel or in notepad, notepad++, etc.

Could you please tell me how I can convert the data type of columns to a numeric type (integer or decimal)?

Big thanks!


Regards

Sylvan