topic Re: Keep last record per date, per person in App Development

Keep last record per date, per person

Thu, 29 Sep 2016 15:09:31 GMT

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!

Re: Keep last record per date, per person

sunny_talwar — Thu, 29 Sep 2016 16:32:09 GMT

Are you looking for this in the script?

Re: Keep last record per date, per person

Thu, 29 Sep 2016 16:33:17 GMT

Yes.

Re: Keep last record per date, per person

sunny_talwar — Thu, 29 Sep 2016 16:43:09 GMT

May be like this:

LOAD Accounting_End_Date,

Timekeeper_Initials,

MaxString(Hist_Title) as Hist_Title

FROM....

Group By Accounting_End_Date, Timekeeper_Initials;

Re: Keep last record per date, per person

Gysbert_Wassenaar — Thu, 29 Sep 2016 16:44:58 GMT

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

;

Re: Keep last record per date, per person

Thu, 29 Sep 2016 17:09:25 GMT

That worked! Thank you!

Re: Keep last record per date, per person

Thu, 29 Sep 2016 17:09:41 GMT

This also worked. Thank you very much!