Can't get Join To Work

Anonymous — Fri, 24 Aug 2018 18:30:42 GMT

Hey All,

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)

GROUP BY 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

ORDER BY Quota.Material,

Quota.Plant,

Quota.QuotaArrange;

Re: Can't get Join To Work

swuehl — Sat, 25 Aug 2018 16:24:53 GMT

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?

topic Re: Can't get Join To Work in App Development

Can't get Join To Work

Re: Can't get Join To Work