Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Give the same alias to the CustomerID in customers as well as sales. They will join. Below Customers: mention inner join(Sales)
I am only creating individual QVDs and I don't want to join them yet....
You might be lookin for Incremental load. First time normally all data is loaded without transformation.
I don't understand what you are saying, sorry. IS there a way to lookup on the table that is loaded?
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.