Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Workflow recreation and assistance

Thiviya
8 - Asteroid

Hi,

 

I would like to do further work on this attached workflow. For some reason when the return date and the next departure date is same it is not picking up correctly. i have use the formula provided on the previous discussion. Also I am having issues with using continuous days and aggregate to number of days . It is splitting up the details.

 

If there is someone willing to work with this workflow, happy to message separately to get through few teething issues on this workflow.

 

 

Attached the file I am expecting to see where when in a year  employee go few different times but then it is continuous and need to provide the breakdown as highlighted  - output file.

 

Thanks

 

 

 

2 REPLIES 2
caltang
17 - Castor
17 - Castor

Can't see the input as you gave a .yxmd file. Export your workflow like so: https://www.thedataschool.co.uk/stephanie-kearns/save-alteryx-workflow-packaged-file/

 

Without the assets, we don't know what you're talking about. Also, who built this workflow? Someone from the community or someone from your company?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Thiviya
8 - Asteroid

We had Data school to assist us with the few different project at the same time. There isn't enough time to understand the technicality of the tax issues so only the basic were done , but then I did go through the community and get few things to fix it. 

 

However it needs bit more clarity on the continuous days based on the report without changing the original report and need to summarise in a particular way. I have removed some of the information, but hopefully I can resolve some of the basics of the report. 

Labels
Top Solution Authors