Keep last record per date, per person

[#1]

Hello, I am having a little trouble filtering my data.. I have titles for employees by month. If someone's title changes in a certain month, I want only one of the records ( I don't care if it's the first or the second). I can't seem to figure out how to do this. Below is a screenshot of what I am referring to.

Thank you!

[sunny_talwar]

Are you looking for this in the script?

[#3]

Yes.

[sunny_talwar · Accepted solution]

May be like this:

LOAD Accounting_End_Date,

          Timekeeper_Initials,

          MaxString(Hist_Title) as Hist_Title

FROM....

Group By Accounting_End_Date, Timekeeper_Initials;

[Gysbert_Wassenaar]

Try the FirstValue or LastValue function:

LOAD

     Accounting_End_Date,

     Timekeeper_initials,

     FirstValue(Hist_Title) as Hist_Title

FROM

     ...

GROUP BY

     Accounting_End_Date,

     Timekeeper_initials

     ;

[#6]

That worked! Thank you!

[#7]

This also worked. Thank you very much!