topic Exporting QVD to CSV via Script is Rounding Numbers in QlikView https://community.qlik.com/t5/QlikView/Exporting-QVD-to-CSV-via-Script-is-Rounding-Numbers/m-p/133508#M601860 <HTML><HEAD></HEAD><BODY><DIV>Hello,</DIV><DIV>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.</DIV><DIV> </DIV><DIV>Example when exporting via script: "1,189,317"</DIV><DIV>Example when exporting via GUI table: 1189316.86</DIV><DIV> </DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Activity:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> *,<BR /> </SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /> [testqvd.qvd]<BR /> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">qvd</SPAN><SPAN style="font-size: 8pt;">); </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"><BR /></SPAN></DIV><DIV><DIV><STRONG>store * </STRONG></DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">from</SPAN><SPAN style="font-size: 8pt;"> Activity </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">into</SPAN><SPAN style="font-size: 8pt;"> [data.csv] (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">txt</SPAN><SPAN style="font-size: 8pt;">); </SPAN></DIV><DIV><DIV> </DIV></DIV><DIV><DIV> </DIV></DIV><DIV><DIV> </DIV></DIV></DIV><DIV>Appreciate any help with this one, I hope it's an easy one.</DIV><DIV> </DIV><DIV>Thanks</DIV><DIV> </DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Wed, 24 Oct 2018 13:46:03 GMT Anonymous 2018-10-24T13:46:03Z Exporting QVD to CSV via Script is Rounding Numbers https://community.qlik.com/t5/QlikView/Exporting-QVD-to-CSV-via-Script-is-Rounding-Numbers/m-p/133508#M601860 <HTML><HEAD></HEAD><BODY><DIV>Hello,</DIV><DIV>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.</DIV><DIV> </DIV><DIV>Example when exporting via script: "1,189,317"</DIV><DIV>Example when exporting via GUI table: 1189316.86</DIV><DIV> </DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">Activity:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> *,<BR /> </SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /> [testqvd.qvd]<BR /> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">qvd</SPAN><SPAN style="font-size: 8pt;">); </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"><BR /></SPAN></DIV><DIV><DIV><STRONG>store * </STRONG></DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">from</SPAN><SPAN style="font-size: 8pt;"> Activity </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">into</SPAN><SPAN style="font-size: 8pt;"> [data.csv] (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">txt</SPAN><SPAN style="font-size: 8pt;">); </SPAN></DIV><DIV><DIV> </DIV></DIV><DIV><DIV> </DIV></DIV><DIV><DIV> </DIV></DIV></DIV><DIV>Appreciate any help with this one, I hope it's an easy one.</DIV><DIV> </DIV><DIV>Thanks</DIV><DIV> </DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Wed, 24 Oct 2018 13:46:03 GMT https://community.qlik.com/t5/QlikView/Exporting-QVD-to-CSV-via-Script-is-Rounding-Numbers/m-p/133508#M601860 Anonymous 2018-10-24T13:46:03Z