Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create add the following data in the script. I have the following logic:
Load id, MonthYear, max(date) resident table group by ID, MonthYear
My question is: if the month year does not have a field to max, I want to min the first field and past it into the month year field for the missing month.
I'm not sure how to incorporate this logic.
Thanks