topic Re: Not able to load the qvds in QlikView

Not able to load the qvds

ferha_jafri — Wed, 09 Oct 2013 08:52:49 GMT

Hello everyone,

I am facing an issue as i am not able to load the qvds when i am loading them i can see all the data fetched but the window stuck at the last table ,only one table qvd is loading if i load more than one same thing happend.

Thanks in advance

Ferha Jafri

Re: Not able to load the qvds

swuehl — Wed, 09 Oct 2013 09:40:54 GMT

Hard to say what the issue is.

Do the qvds share a lot of common field names, but are not identical in number and names of fields?

Then you maybe create a huge synthetic key, which may stall your computer.

If this is the case, you need to decide how you want to model your data, you can only load the fields necessary, rename fields on load (or use qualify statement), or concatenate the qvd data into a large fact table, or...

Re: Not able to load the qvds

sathishkumar_go — Wed, 09 Oct 2013 10:27:31 GMT

Hi, Use Qualify * statement in the above of the 1st table. so that we will come to know what is the issue? means issue in your data modelling. Regards Sathish

Re: Not able to load the qvds

saumyashah90 — Wed, 09 Oct 2013 10:30:54 GMT

Yes use Qualify Statement

and before hand just see if there are too many synthetic key's getting formed will also lead to the same problem

Synthetic key gets formed when you get more than one common field from other tables you load.

Re: Not able to load the qvds

suniljain — Wed, 09 Oct 2013 10:33:41 GMT

Can you post log file of that application ?.

Re: Not able to load the qvds

ferha_jafri — Thu, 10 Oct 2013 03:49:28 GMT

Thanks everyone, the reason was that the data model has a large no. of common fields i renamed them an now i am able to load the qvds ,thanks again.

Re: Not able to load the qvds

ferha_jafri — Thu, 10 Oct 2013 03:50:39 GMT

Thanks Swuehl you are correct now, everything seems fine.