Skip to Content
Apr 09, 2015 at 02:24 AM

Scientific Notation in a table Column in HANA


Hi All.

We are in the process of creating a prototype for a healthcare customer.

As a part of this, I am trying to load some data from a flat fie provided by the customer.

The flat file has a column named PT_ID which has values like the following:

But when I take it to my table in HANA using ‘Import from Local File’, my table data looks like this:

Could some body help me out with a solution to avoid this Scientific notation (like 3.9729904E7)coming in for the column PT_ID

Am on Revision 92 and the data type of the field PT_ID is NVARCHAR 11 (Proposed by the system and the maximum length seen in the source excel is only 8).




Capture1.JPG (35.4 kB)
Capture2.JPG (30.8 kB)