Alteryx Designer Desktop Discussions

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

Assign Business Days base on a date column

HassimDiallo
6 - Meteoroid

I am working on a complex workflow and need to create a status column. Here are details and assumption i am making

  1. i am sorting my data so that most recent month is first
  2. i want to reflect Business Days for the most recent month only
  3. For the most recent month, IE: May,  posting date that falls within last four business days will be recorded next month due to "Timing".  Thus, i need the status to reflect the word "Timing"
 
 
 
 

Timing.PNG

2 REPLIES 2
jeff_reynolds
10 - Fireball

Try the attached workflow. I think it will do what you need. 

 

There are a lot of places where it could be tightened up, but I left it all in so you could see what it does.

 

Good luck. 

 

HassimDiallo
6 - Meteoroid

Thank you Jeff. This should definitely do the trick! i will incorporate the logic in my workflow.

Labels