3 Replies Latest reply: Jun 2, 2015 8:36 AM by Jonathan Dienst RSS

    Storing table to text files

    Shannoy Panankoodan

      MyTable:

      LOAD

      Country&'|'&Month&'|'&Val as Fulldata

      FROM

      [C:\\Desktop\1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      STORE MyTable INTO MyCSVFile.csv (txt);

       

      The field "Val" has decimal values till 8. But when I store it to "MyCSVFile.csv" it takes only till 2 decimal places.

       

      Please let me know how to maintain the same formatting.

       

      TIA,

       

      Shannoy