Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
ijmiller16
New Contributor

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