I'm pretty new to Qlik but not SQL. I'm trying to do a join on two loaded tables but keep getting an error at load that it can't find the Quota table. What am I doing wrong
[Source]:
LOAD*
RESIDENT [sourceTable];
DROP TABLE [sourceTable];
[Quota]:
LOAD*
RESIDENT [quotaTable];
DROP TABLE [quotaTable];
SQL
SELECT Quota.Material,
Quota.Plant,
Quota.BuyerCode,
Quota.BuyerName,
Quota.SBM,
Quota.QuotaArrange,
Quota.QuoteVendorCode,
Quota.QuoteVendor,
Quota.QuoteValidFrom,
Quota.QuoteValidTo,
Quota.QUOTE,
Quota.Quota,
Source.SourceVendorCode,
Source.SourceVendor,
Source.SourceValidFrom,
Source.SourceValidTo,
Source.Fix,
Source.MRP
FROM Quota LEFT JOIN Source ON (Quota.QuoteVendorCode = Source.SourceVendorCode) AND (Quota.Plant = Source.Plant) AND (Quota.Material = Source.Material)
Your SQL SELECT statement is executed by the SQL driver on an external DBMS. Is table Quota part of that external DB? Or are you trying to acces the Qlik resident table Quota, which is outside the realm of the DBMS?
