Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
How many rows Loans table have?
What do you intend with FirstSortedValue(prod_dt, prod_dt) ? Min(prod_dt) isn´t enough?
How many rows Loans table have?
What do you intend with FirstSortedValue(prod_dt, prod_dt) ? Min(prod_dt) isn´t enough?