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).