Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
MyTable:
LOAD
Country&'|'&Month&'|'&Val as Fulldata
FROM
(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
Hi Shannoy,
can you upload your xlsx please?
Andy
In a textual keyfield, instead of Val use Num(Val, FormatString') where you replace FormatString with a proper format e.g. '#0.00000000' (assuming you use US decimal separators)
Peter
Perhaps
LOAD
Country&'|'&Month&'|'&Text(Val) as Fulldata
FROM