Monthly Employee Turnover (Joiners v Leavers)
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
Cozdis93
6 - Meteoroid
‎03-10-2021
09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone!
I am trying to determine what are the joiners and leavers monthly based on the client data provided.
So far the only way I have been able to do this, is by filtering on the date i.e. January to February and then using the join tool to find what are the IDs that get "filtered" out.
I need to do this for 24 months and this feels liek a very manual process.
See attached below my zip file.
Labels:
- Labels:
- Tips and Tricks
- Transformation
- Workflow
2 REPLIES 2
Maskell_Rascal
13 - Pulsar
‎03-10-2021
10:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Cozdis93
Can you share the input file with me, or at least a sample of what it looks like? The zip didn't include it.
Thanks!
Phil
‎03-10-2021
10:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
