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.

Counting Between Business Days from a List

briankuhlmann
8 - Asteroid

bizdays.PNG

I have a DB with 5 years of biz days and non biz days (weekends and holidays) 

 

I need to be able identify how many biz days between an order placed and an order delivered using this db as the key.

 

Any suggestions?

1 REPLY 1
MattBSlalom
11 - Bolide

Unfortunately, the Join tool in Alteryx doesn't allow the option to join on non-equivalent conditions (like greater than & less than).  This post has a good solution that should work for you using the Generate Rows tool:  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Count-working-days/td-p/672159

 

Another way to work around this is to generate all possible joined result rows using the Append Fields tool, then Filter back down to the rows that actually meet the desired criteria.  Then just Summarize to count the joined rows.  I've attached a sample workflow using this method.

 

MattBSlalom_0-1614720426521.png

 

Labels