Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exporting QVD to CSV via Script is Rounding Numbers

Hello,
I am relatively new to scripting and have tried researching through this problem. I have a large QVD of about 10 million lines and I am trying to extract to a CSV via Script since it processes exponentially faster than trying to extract using the GUI from a table. The major difference is that the number values are rounding to whole numbers when attempting the below Script, whereas exporting through the GUI into a CSV preserves the decimals.
Example when exporting via script: "1,189,317"
Example when exporting via GUI table: 1189316.86
Activity:
LOAD *,

FROM
[testqvd.qvd]
(
qvd);

store *
from Activity into [data.csv] (txt);
Appreciate any help with this one, I hope it's an easy one.
Thanks
Labels (1)
0 Replies