Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date condition

harithad1
7 - Meteor

 

Need help with the below table.

 

 

Ticket open dateTicket resolved dateNet working daysWithin / outside limit
3/18/2023 3:55:36 AM3/23/2023 9:36:38 PM4Outside limit

 

If the networking days are less than 4, then it is considered "within limit"; otherwise, it is "outside limit". However, if there is a holiday between the ticket open date and resolved date, the net working days column will remain the same, but the limit for networking days will increase by the number of holidays. For example, if there is one holiday between the open and resolved dates, then the limit should be 5 for evaluating whether it is within or outside the limit.

 

For this, i have a list of holidays in a separate input file. Please help me incorporate this in my workflow.

 

Thanks

2 REPLIES 2
OTrieger
12 - Quasar

@harithad1 

What have you done so far to resolve that issue? Or what is your thought process on how to solve it from the given data?

Raj
16 - Nebula

@harithad1 
share the workflow 
will be in better condition to help.

Labels
Top Solution Authors