Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Pulling the data from Qlik and storing it on local file system

Hi Everyone,

Is there any way that we can pull the data from Qlik and store it on local file system?


Thanks

Spandan

2 Replies

Re: Pulling the data from Qlik and storing it on local file system

Yes it's possible, see: Extracting Data from a QlikView Application

- Marcus

MVP
MVP

Re: Pulling the data from Qlik and storing it on local file system

And in addition to using the STORE statement you can also use the SQL statement like for instance this:

FOR i=1 TO NoOfRows('aTable')

     vID = Peek('ID',i-1,'aTable');

     vProduct = Peek('Product',i-1,'aTable');

     SQL

          INSERT INTO myDBTABLE VALUES ($(vID),'$(vProduct)')

     ;

NEXT;

It might not be very speedy but it does the job. You can even use an insert with multiple rows in one insert statement to optimize the batch size.

Community Browser