We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

How to fetch rows dynamically in the worksheet based on assignment changes happened in the plan year

Received Response
edited Aug 3, 2021 4:30PM in Compensation 1 comment


Hi All,

We have a scenario where clients wants to fetch more than one row for the same employee when their assignment record changes.

For e.g Plan year - 2021

HR Extraction date - 1-July-2021

Employee A - Grade change from 24 to 25

so we need two rows for the same employee with one row grade as 24 and another row grade as 25.

IF we have three changes in a year we need three rows.

So is this requirement achievable please let me know your suggestion.





Howdy, Stranger!

Log In

To view full details, sign in.


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