Is outer Join better doing in QV or before Load?

Thu, 25 Aug 2011 10:05:10 GMT

Hello Experts, I am looking for someone who can help me with the below SQL script. I am looking to join the PaymentKey with that of a YearMonth in a different table as seen below, tried doing it in QV but gives me Memory Timed out error message, Can anyone suggest a best solution or help me with the below?

Consecutive_Amounts:

LOAD

Amount,

PaymentKey,

YearMonth;

SQL SELECT Amount,

PaymentKey,

YearMonth

FROM "AOF_DataMart".Reporting.vLastFctPayment

Where PortfolioKey = $(vPortfoliokey)

(SELECT PaymentKey,

YearMonth

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

Order By YearMonth;

Thanks in Advance,

Mady

topic Is outer Join better doing in QV or before Load? in QlikView

Is outer Join better doing in QV or before Load?