topic Loading Tables in QlikView

Loading Tables

Wed, 07 Mar 2012 16:38:32 GMT

Hi All,

I am loading a table from SQL Server using the script:

Sales:

Select Customer ID,

SalesAmount,

Date

.FROM tblSales

Now in the second tab, I want to load customers.

Customers:

SELECT

Customer ID,

Name

FROM Customers

When I load customers, I only want to load all the customers where the Customer ID is in the Sales table that I loaded before. However, I don't want to hit SQL Server when I am loading Customers as there might be new customers with sales in the system that didn't make into the Sales table when the sales table was loading. in other words, when loading customers, I want to lookup on the Sales table that is already loaded in QlikView.

Any ideas how to do this?

Loading Tables

rajeshvaswani77 — Wed, 07 Mar 2012 16:54:41 GMT

Give the same alias to the CustomerID in customers as well as sales. They will join. Below Customers: mention inner join(Sales)

Loading Tables

Wed, 07 Mar 2012 16:59:31 GMT

I am only creating individual QVDs and I don't want to join them yet....

Loading Tables

rajeshvaswani77 — Wed, 07 Mar 2012 17:07:26 GMT

You might be lookin for Incremental load. First time normally all data is loaded without transformation.

Loading Tables

Wed, 07 Mar 2012 17:09:31 GMT

I don't understand what you are saying, sorry. IS there a way to lookup on the table that is loaded?

Loading Tables

rajeshvaswani77 — Wed, 07 Mar 2012 17:14:56 GMT

You need to do it in your SQL itself with database then. Thats the fastest way you could do. I do not think you can do the way you are asking.