Alteryx Designer Desktop Discussions

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

Find 15th workday of next month basis start date

Shaaz
9 - Comet

Hi,

 

I'm trying to find 15th workday of next month basis start date excluding weekend.

 

Below is the sample input along with expected output.

 

Shabaz_1-1653029664899.png

 

Can you please help me in achieving this.

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@Shaaz 
I thought it should be very simple

😂

0520-Shabaz.PNG

binuacs
20 - Arcturus

@Shaaz Similar to @Qiu solution

 

binuacs_0-1653032464421.png

 

Shaaz
9 - Comet

Hi,

 

Thank you, I'm able to achieve what is expected from the above 2 solutions.

 

But is there a much more optimized way to achieve this, since Generate Rows tool will increase the record count and degrade the performance of overall Alteryx run time since I'm working on millions of rows.

Shaaz
9 - Comet

--

binuacs
20 - Arcturus

@Shaaz you should get same number records in input and output . Can you check which date you are missing the output?

Labels