Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Monthly Employee Turnover (Joiners v Leavers)

Cozdis93
6 - Meteoroid
‎03-10-2021 09:12 AM

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.

Joiners-Leavers (1).yxzp
Reply
0 Likes
2 REPLIES 2
Maskell_Rascal
13 - Pulsar
‎03-10-2021 10:01 AM

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

Reply
0 Likes
Cozdis93
6 - Meteoroid
‎03-10-2021 10:36 AM

Hi @Maskell_Rascal 

 

Thanks  for letting me know, this one should work let me know if it doesn't!

Joiners-Leavers (1).yxzp
Reply
0 Likes
Join the weekly challenge takeover
Join the tampa, florida User Group
Labels