topic Extract Do not Pull all no. of records from SQL server database in QlikView

Extract Do not Pull all no. of records from SQL server database

Wed, 27 Jun 2012 05:48:30 GMT

Extract Do not Pull all no. of records from SQL database hence size of qvd file remain small. Aftre re-running same extract multiple time, it pull all data from database.

Any suggestion on this issue or anyone has faced similar issue ?

Regards

-Vinit

Re: Extract Do not Pull all no. of records from SQL server database

Jason_Michaelides — Wed, 27 Jun 2012 07:09:43 GMT

You need to provide some more information. What do you mean by "Extract do Not Pull"? What are you trying to do an what do you want to see at the end of it? Can you provide examples?

Jason

Re: Extract Do not Pull all no. of records from SQL server database

Wed, 27 Jun 2012 07:29:59 GMT

Hi Jason,

Thanks for responding.

The problem that i am facing is as follows -

We have dataware house built in SQL server database. As a frontend we are using QlikView dashboard.

the process is that,

1. QlikView extracts data from the SQL server db and creats .qvd files

2. qvd files that are generated in first step are used to build dasboard (.qvw).

We have noticed that in step 1 we infrequently get a lesser sized .qvd files, in such instances we rerun the extract, sometime 2-3 times until it generates .qvd file with a correct size.

The logs do not show any errors however, data feteched in subsequent extracts is greater than the previous ones.

Hope this helps. let me me if you need anymore info.

P.S. your profile photo looks amazing

Thanks

Vinit

Re: Extract Do not Pull all no. of records from SQL server database

Jason_Michaelides — Wed, 27 Jun 2012 17:54:35 GMT

Can you provide an example of your script? Are you using SELECT * or naming fields? Are you using a preceding LOAD?

PS - thanks 😉