Get Corresponding Salary Month Columns till the last date of each employee as per id
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
harshal98
8 - Asteroid
‎12-15-2020
06:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Based On Employee ID, get Corresponding salary written in the month columns till the last effective date of that employee arises.
Labels:
- Labels:
- Best Practices
- Datasets
- Input
- Join
- Preparation
2 REPLIES 2
AngelosPachis
16 - Nebula
‎12-15-2020
08:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @harshal98 ,
Here is a workflow for the task. Essentially on the bottom part I am just generating every month-year from one effective date to the next.
The Joining on the main dataset and cross-tabing to bring it in the correct format.
Let me know if you have any questions on the workflow and if that's what you've been looking for.
Regards,
Angelos
AngelosPachis
16 - Nebula
‎12-22-2020
09:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @harshal98 ,
If the above response answers your question, can you kindly mark it as a solution to close this thread?
Cheers,
Angelos