SQL outer join better or within in QV?

Thu, 25 Aug 2011 10:01:36 GMT

Can someone help me to do an Outer join with this below script? I was trying to do it in QV but I get an Memory Timed Out error, so thought would do it before even loading as seen below. Can someone suggest a solution for this please? I have a Error regarding the below SQL script, which I am not able to crack.

Consecutive_Amounts:

LOAD

Amount,

LoanKey,

YearMonth;

SQL SELECT Amount,

LoanKey,

YearMonth

FROM "AOF_DataMart".Reporting.vLastFctPayment

Where PortfolioKey = $(vPortfoliokey)

(SELECT LoanKey,

YearMonth

FROM "AOF_DataMart".Reporting.LoanByYearMonth) Outer Join LoanKey on LoanKey

Order By YearMonth;

Thanks,

Mady

SQL outer join better or within in QV?

sbaldwin — Fri, 26 Aug 2011 12:26:00 GMT

Hi, have you tried changing your SQL to be something like this:

Consecutive_Amounts:

LOAD

Amount,

LoanKey,

YearMonth;

SQL SELECT

lp.Amount,

lp.LoanKey,

lbm.YearMonth

FROM "AOF_DataMart".Reporting.vLastFctPayment lp

left outer join "AOF_DataMart".Reporting.LoanByYearMonth lbm on lp.LoanKey = lbm.lp.LoanKey

Where PortfolioKey = $(vPortfoliokey)

Thanks

Steve

topic SQL outer join better or within in QV? in QlikView

SQL outer join better or within in QV?

SQL outer join better or within in QV?