Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shannoypaul
Contributor

Storing table to text files

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

3 Replies
awhitfield
Esteemed Contributor

Re: Storing table to text files

Hi Shannoy,

can you upload your xlsx please?

Andy

Re: Storing table to text files

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

MVP
MVP

Re: Storing table to text files

Perhaps

LOAD

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

FROM

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein