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

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
22 - Nova
22 - Nova

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
20 - Arcturus
20 - Arcturus

@atcodedog05 

Nicely done.

And welcome back!😁

AHM
7 - Meteor

@atcodedog05 

 

Thank you SOOOOOOOOO MUCH

Labels