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;
