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

    left join new customers issue

    Amien Amien


      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?