Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

left join new customers issue

facts:

LOAD CustomerID, CustomerName, Value

RESIDENT table1

LEFT JOIN (facts)

LOAD CustomerID, CustomerEnabled

RESIDENT table2

table1 contains all customers, table2 contains not all customers.

i want in the end that all CustomerID's have an CustomerEnabled flag, even the customers that are in table1, but not in table2

can this be done, without loading the complete 'fact' table all over again?

0 Replies