Skip to main content
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
0 Replies