Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Please assist, I need to load data from a qvw using a Binary load, once i have the data from that qvw I need to store it into a .txt file
is it possible to store a binary load into a qvd or .txt file? im getting the error that the table does not exist when I use the below script
Binary "C:\Documents and Settings\T.PC\Desktop\Adhoc functions\Customer Spend.qvw";
Store "C:\Documents and Settings\T.PC\Desktop\Adhoc functions\Customer Spend.qvw" into
Any Idea what im doing wrong... or if this is possible?
Regards,
you cannot save the entire binary load into a text file, you can only save the tables that are present in the binary file or qvd into a text or csv file.
customer spend.qvw is now loaded into your app once the binary script is loaded,
The app will then have all the tables that are present in the Customer Spend.qvd,
you can see them in the table viewer(ctrl + t).
Now try to store them table by table into text files.
hope this helps
-Sundar
Hi
A qvw file (and the binary loaded file) can contain multiple tables. A qvd file or a csv/txt file stores a single table.
To save the binary loaded data in qvds, you could loop over the tables and perform a store operation on each table.
HTH
Jonathan
Thank you! This worked
Ridhaa Hendricks
Data Analyst
0842276595
r.hendricks@cellc.co.za
This email and its contents are subject to our email legal notice which can be viewed at http://www.cellc.co.za/dl/cms/downloads/Email_legal_notice.pdf
Hi,
Can u please tell wat is ur exact requirement??
If u want to store ur script, then u can use the export to script file option.
HTH
-Shruti