Joining full calendar dates to Leave dates

[Saravanan13]

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.

[Felipe_Ribeir0 · Accepted solution]

Hi @Saravanan13 

Please see if i understood correctly

[ShankerV · Accepted solution]

Hi @Saravanan13 

Please find the below expected output.

[Saravanan13]

Thank you so much Felipe. It worked perfectly.

[Saravanan13]

Thank you so much Shanker. It worked perfectly.