Help Identifying New Jobs

Question

Hello - I am trying to identify the first time a new job shows up in the attached data set. For this request, I consider a "new job" to be any time a job code appears in the list for the first time with the Department name listed in the "OrgLevel3Desc" column. Would appreciate any help on the best way to identify these across the multiple rows.

Job History after 01012021.xlsx

ccanterman · Answer

@SPetrie - Oh, those are spiffy ways to solve it. I feel like this is the second or third time that I've answered something and then you've had a much prettier answer. I'll get you next time ;)

SPetrie · Answer

Another option is to use a unique tool, or a sample tool set to the first 1 row.

It will gab the first item, so in both options you need to have your data sorted into the proper order. Use by date or whatever method you think is appropriate for your results. Select your grouping columns for your first criteria and you are set. If you want the first time the job code and OrgLevel combo appears, select those two columns.

first.yxmd

ccanterman · Answer

Same as described above except I changed the Sort to use Effective Date instead of RecordID since I probably should've done that to begin with :)

My assumption was that the data was already in the order you wanted to keep it, but that's not a good assumption to make

Sample WF.yxzp