Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Joining full calendar dates to Leave dates

Saravanan13
8 - Asteroid

Hello all,

 

I looking to join the two attached data sets, I want separate rows to be created for each employee as to when they have taken leave and when they haven't taken a leave. Attached dataset has dates from November and December. Can anyone assist on this.

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @Saravanan13 

 

Please see if i understood correctly

Felipe_Ribeir0_0-1672750159920.png

 

ShankerV
17 - Castor

Hi @Saravanan13 

 

Please find the below expected output.

 

ShankerV_0-1672751247908.png

Saravanan13
8 - Asteroid

Thank you so much Felipe. It worked perfectly.

Saravanan13
8 - Asteroid

Thank you so much Shanker. It worked perfectly.

Labels