Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be like this:
LOAD Accounting_End_Date,
Timekeeper_Initials,
MaxString(Hist_Title) as Hist_Title
FROM....
Group By Accounting_End_Date, Timekeeper_Initials;
Are you looking for this in the script?
Yes.
May be like this:
LOAD Accounting_End_Date,
Timekeeper_Initials,
MaxString(Hist_Title) as Hist_Title
FROM....
Group By Accounting_End_Date, Timekeeper_Initials;
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
;
That worked! Thank you!
This also worked. Thank you very much!