Doing a Binary load and store that data into a txt file

[rido1421]

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,

[sundarakumar]

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.

[sundarakumar]

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

[jonathandienst]

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

[rido1421]

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

[#6]

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