Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table with a field of eventdates (diffrent dates for diffrent persons) and a field of maxdate (also diffrent for diffrent persons). I want to only load those eventdates that occurs between min(eventdates) (that field also exist) and the maxdate for each person.
Should I use some sort of loop trought each persons eventdates against the persons maxdate or how to solve it?
I would also like to flag the second eventdate for each person.
Any suggestions are mostly appriated. Thank!
I have attached a qvd with sample data.
Data:
LOAD EventDates,
Id,
MaxDate2,
MinDate_EventDate
FROM [comm121914.qvd] (qvd)
where EventDates < MaxDate2 and EventDates > MinDate_EventDate;