topic Re: Data LOAD from multiple tables in QlikView

Data LOAD from multiple tables

Wed, 09 Jan 2013 14:13:27 GMT

Please see attached file for all the tables and fields.

MARGIN_FACT and POSITION_FACT are concatenated.

I need to produce a table with the following fields:

- Exhange

- Contract Code

- Contract Description

- Aggregate Quantity

- Initial Margin

All this data comes from multiple tables which are linked in a complex way (you can see in the attached file).

I am trying to write the LOAD code to load all the needed fields so that I would be able to create the straight table. However, I tried many ways but there's always some problem, either a field is not showing or showing wrong data.

Please could anyone give me any advice.

Re: Data LOAD from multiple tables

Wed, 09 Jan 2013 14:19:48 GMT

Now every time I try to reload, I get the following error message:

Server Deployment Compatibility Warning

Internal inconsistency, type D, detected.

If this application is deployed on a server, the server will restart with the message above written to the event log.

Please contact QlikTech support for further assistance.

Re: Data LOAD from multiple tables

shree909 — Wed, 09 Jan 2013 14:27:22 GMT

Even i had the same issue the thing is

first u need to avoid any sysnthetic keys it had

second if ur using more if conditions on the front end u may end endup getting

third it depends on how many records were present .

if ur datmodel is not properly designed u will get this type of error or ur running short of memory.

if the ram on ur desktop is less like 2gb then also u will get this ...

Re: Data LOAD from multiple tables

Wed, 09 Jan 2013 14:30:29 GMT

How would I avoid the syn keys? I think it might be one of the problems as I usually get the error after it starts creating them.

The number of records from one table is about 3mln, that's the highest, from other tables it's only about 15,000 records.

It used to be fine, no errors or problems when reloading the data and it just suddenly started for some reason

Re: Data LOAD from multiple tables

shree909 — Wed, 09 Jan 2013 14:32:59 GMT

can u post the sample of the file like datamodel image..

Re: Data LOAD from multiple tables

Wed, 09 Jan 2013 14:44:53 GMT

I am not sure if you can see, but there are loads of syn keys. And this does not include all the tables, some more will have to be added later. Any ideas how to get rid of them?

Sorry for the quality, for some reason the picture saved differently than it looked on the screen.

Re: Data LOAD from multiple tables

Wed, 09 Jan 2013 14:50:58 GMT

Just figured out, that I might be getting this error because of licensing issues.

Re: Data LOAD from multiple tables

shree909 — Wed, 09 Jan 2013 15:13:08 GMT

can you comment the fields which are on dimensions

or try to use a

autonumber hash( cal date,exchange , participatio......) as linked_key

after making this on every table then comment all the fields which are on dimenion side..

and try to get the star schema..

can u please attach a sample of qvw.. with limited rows

Re: Data LOAD from multiple tables

Thu, 10 Jan 2013 15:38:49 GMT

i am going to try this method :

autonumber hash( cal date,exchange , participatio......) as linked_key

just one question, would i create this key in multiple tables and give it the same name? or would the key name have to be different for all the tables?

i.e. cal date, exchange - linked key

cal date, exchange, participation - linked key 2

cal date, exchange - linked key

cal date, exchange, participation - linked key

i am a complete newbie to this, sorry for asking too many questions

Re: Data LOAD from multiple tables

shree909 — Thu, 10 Jan 2013 19:55:58 GMT

FIRST IDENTIFY WHAT ALL THE COMMON FIELDS YOU HAVE IN THE TABLES.

SEE WHAT MAKES THE SYSNTETIC KEY. TRY TO MAKE ALL THE FIELDS OF SYNTHETIC KEY AS LINKED KEY..

IF YOU STILL NOT FOLLOW POST AN SAMPLE FILE.

Re: Data LOAD from multiple tables

Fri, 11 Jan 2013 11:49:31 GMT

See attached file, I can't upload other tables as I still keep getting that error.