Alteryx Designer Discussions

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

Dates Help plz

AHM
7 - Meteor

Hi all, 

 

I need help plz. So, usually I have to check if employees took breaks during the year, and if they did I have to say from when to when. 

for example, 

AHM_0-1616253969287.png

and I have to make it look like this, 

AHM_1-1616254022705.png

 

 

What I usually did on excel was that I did a pivot table to find the count

AHM_2-1616254064172.png

and then do a VLOOKUP for the counts, and if an employee had only one break, I would just do a VLOOKUP for the date. If employee had 2 breaks, I would use Min and Max. But If they had 3 or more then I would do it manually.

 

Can somebody suggest a way I can do it on Alteryx?  

3 REPLIES 3
atcodedog05
21 - Polaris

Hi @AHM,

 

This can be achieved by performing couple of steps.

 

Workflow:

atcodedog05_0-1616267708978.png

 

Step -1 : I am doing a groupby on employee ID and getting the row came back from break

atcodedog05_1-1616267785482.png

Step -2 : I am creating the verbiage where for the ones which have from and to dates

 

atcodedog05_2-1616267859198.png

Step - 3: I am grouby employee id and concatenating breaks with separator ".And " 

atcodedog05_3-1616267930205.png

Step - 4: As a last step i am adding Yes where breaks were not empty and No where breaks where empty.

 

Output:

atcodedog05_0-1616268128290.png

 

Hope this helps 🙂

Qiu
17 - Castor

@atcodedog05 

Nicely done.

And welcome back!😁

AHM
7 - Meteor

@atcodedog05 

 

Thank you SOOOOOOOOO MUCH

Labels