Using Outer Join consumes additional memory when loading?

Mon, 26 Jan 2026 18:19:17 GMT

Hello Experts,

I have 2 tables Table1 , Table 2 both have yearmonth and Customer fields. But in Table 1 I have a date for customer only when he paid an Amount so its limited, and In Table2 I have each yearmonth for each customer irrespective of their payments.

I am doing something like below:

Table1:

Load YearMonth,

Customer,

Sales

From XYZ.Table

Table2:

Outer Join (Table1)

Load YearMonth,

Customer

From ABC.Table

But the above gives me Memory Timed out error. When I do a normal Join it looks like it works but I want an Outer Join so that I can have a YearMonth per Customer for an Amount paid and Blank if not.

topic Using Outer Join consumes additional memory when loading? in QlikView

Using Outer Join consumes additional memory when loading?