1 Reply Latest reply: Nov 17, 2015 11:42 AM by Clever Anjos RSS

    Why does this combination not work?

    Matt Maino

      The code in the black text works on its own, but when I add the code highlighted in red it freezes up. Does it have something to do with using the same table (Loans) twice?

       

      Thanks.

       

      Date_First_120:

      LOAD

      acct_nbr,

      FirstSortedValue(prod_dt, prod_dt) as Date_First_120

      Resident Loans

      Where days_in_arears >= 120

      Group by acct_nbr;

       

      Left Join (Loans)

      LOAD distinct *

      Resident Date_First_120;

      Drop Table Date_First_120;

       

       

      Date_First_30:

      LOAD

      acct_nbr,

      FirstSortedValue(prod_dt, prod_dt) as Date_First_30

      Resident Loans

      Where days_in_arears >= 30

      Group by acct_nbr;

       

      Left Join (Loans)

      LOAD distinct *

      Resident Date_First_30;

      Drop Table Date_First_30;