Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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