Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to get data from a certain date. I have the [Latest Recorded Date] variable already created and working but cannot figure out how to get data thats just from that date specifically. The Tmp table is what i have been attempting but it crashes
LoanLoss2:
Left Join (LoanLoss)
Load
acct_nbr as distinctAcct,
date(max(prod_dt)) as [Latest Recorded Date]
Resident Loans
group by acct_nbr;
Tmp:
Load
days_in_arears as Daysarears,
If(prod_dt = date(max(prod_dt)), days_in_arears, )
Resident Loans;
Hi Ashley
If(prod_dt = date(max(prod_dt)), days_in_arears ) comma not needed if there is no default value.
but what you can do is use EXISTS like
Load
days_in_arears as Daysarears
Resident Loans
WHERE EXISTS([Latest Recorded Date], days_in_arears) // Will take records only if dates match
;
best regards
chris
This crashes the program. Thank you though
Try this
Tmp:
Load
days_in_arears as Daysarears,
Resident Loans Where prod_dt=[Latest Recorded Date];