0 Replies Latest reply: Aug 25, 2011 5:36 AM by Amien Amien RSS

    left join new customers issue

    Amien Amien

      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?