Dates Help plz

[AHM]

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, 

and I have to make it look like this, 

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

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?  

[atcodedog05 · Accepted solution]

Hi @AHM,

This can be achieved by performing couple of steps.

Workflow:

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

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

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

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

Output:

Hope this helps 🙂

[Qiu]

@atcodedog05 

Nicely done.

And welcome back!😁

[AHM]

@atcodedog05 

Thank you SOOOOOOOOO MUCH