Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I am creating a table that displays account numbers and certain dates that correspond with the account number. I am wondering how to only display the earliest date for each account number as opposed to every date for each account number.
Tried using min and firstvalue and couldnt get either to work
LoanLoss:
LOAD
acct_nbr as distinctAcct,
prod_dt as prod_dt2
Resident Loans
where is90 = 1;
Try this
LoanLoss:
Load
acct_nbr as distinctAcct,
date(min(prod_dt)) as prod_dt2
Resident Loans
where is90 = 1
group by acct_nbr;
Eduardo
The min() function should work. You're missing something... Can you upload your QV file?
Try this
LoanLoss:
Load
acct_nbr as distinctAcct,
date(min(prod_dt)) as prod_dt2
Resident Loans
where is90 = 1
group by acct_nbr;
Eduardo
This worked! Thank you!