You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - Work Relationship Start Date

Received Response
edited Aug 20, 2021 7:46PM in Learning 17 comments


Trying to return a single line per employee instead of all dates of job change.


The work relationship start date returns a row of data for employees for each job change. I.e. I was hired as an account exec 1/1/2020 and became a sr account exec on 1/1/2021. There would be a row of data for each. I am trying to figure out how I can filter it to only return the most recent entry so that each employee has a single line of data that shows their current job and when they started. 

Still pretty new to OTBI so I am kind of feeling around in the dark a bit. 


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!