Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
community Alteryx IO MyAlteryx
alteryx Community
Search
Knowledge
  • Global Community
  • This Category
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Networking day
Macros Uploaded by on 02-17-2025 Downloaded 7 times
  • Automation
  • Macros
  • Prep and Blend
    • Download
    0 Likes
    Post Comment

    Description

    use formula to calculate the networking day. 

     

    benefit is faster compared to generate rows method. especially the date range is high (>1000)


    proof: 10k line with random range of 1000 day. 
    time used: 92.11 ms vs 82,134.52 ms

     

    Limitation:

    - Only cover Mon-Fri or Sun-Thu

    - you may use holiday generator as this is not cover.

    Screenshot 2025-02-18 114729.png

     

    Read More
    Attachments
    NetWorking Day example.yxzp
    net working day.yxmc