topic Loading problem in QlikView

Loading problem

Mon, 28 Nov 2011 14:45:37 GMT

Hi all,

I am facing a loading problem, I have three tables: sales, purchase and store and I need to use all of them in a single qvw file.

Now, sales and purchase are indexed by documentID and article, and I have the date; Store is indexed by month-year and article.

Does anyone knows if a loading pattern exists about this problem? Or, how can I "merge" these files?

Thanks in advance

Re: Loading problem

Miguel_Angel_Baeyens — Mon, 28 Nov 2011 14:55:18 GMT

Hi Carlo,

QlikView links tables when one or more fields are named alike. Note that QlikView is case sensitive, so "Field" is not the same as "FIELD". This happens regardless the actual key fields or indexes in the data source.

You can append one table to any previously loaded table using the keyword CONCATENATE before the load, so both tables result in one bigger table.

Sales:
LOAD DocID,
     Item,
     Date,
     'Sales' AS Source;
SQL SELECT *
FROM Sales;
CONCATENATE (Sales) LOAD DocID,
     Item,
     Date,
     'Purchase' AS Source;
SQL SELECT * 
FROM Purchases;
Stores:
LOAD StoreNo,
     Item,
     'Store' AS Source;
SQL SELECT * 
FROM Stores;

Then create a table for the calendar where all possible date related dimensions are stored as in this application.

Hope that helps.

Miguel

Loading problem

Mon, 28 Nov 2011 15:05:33 GMT

Hi Carlo,

without knowing the Data, it cannot be merged. I can propose a Datamodel based on your explanation.

Sales:
Load
     documentID &'_' &article as Key,
     documentID as DocId, // renaming so that no synthetic key arises
     article as Material // renaming so that no synthetic key arises
From Sales;
Purchase:
Load
     documentID &'_' &article as Key,
     documentID,
     article
From Purchase;
Now the next step..I dont know when you meant I have a date, whether it is in Purchase or Sales Table

Store:
Load article,
     Month-year
From Store;

Hope it gives a basic Idea. If data is present in purchase table, you can make a Key between Article and date, like I made between DocumentID and article in first table.

Regards

Sravan