topic Storing table to text files in QlikView

Storing table to text files

shannoypaul — Tue, 02 Jun 2015 12:30:23 GMT

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

Re: Storing table to text files

awhitfield — Tue, 02 Jun 2015 12:32:13 GMT

Hi Shannoy,

can you upload your xlsx please?

Andy

Re: Storing table to text files

Peter_Cammaert — Tue, 02 Jun 2015 12:34:48 GMT

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

Re: Storing table to text files

jonathandienst — Tue, 02 Jun 2015 12:36:17 GMT

Perhaps

LOAD

Country&'|'&Month&'|'&Text(Val) as Fulldata

FROM