Working Date + Holiday date

[AshishAgarwal]

Hi Team,

I want to get dates for Working  + Holiday dates.

I have list of Japan holidays which I can provide as input file.

So I want Alteryx to identify below working date:

1. Working date before Japan Holiday / weekends and Japan Holiday dates.

2. Working date after Japan Holiday and weekends

Sceanrio	Holiday	Result
1	Monday	Friday + Monday
2	Monday + Tuesday	Friday + Monday + Tuesday
3	Friday	Thursday + Friday
4	Thursday + Friday	Wednesday + Thursday + Friday
5	Monday + Tuesday + Wednesday	Friday + Monday + Tuesday + Wednesday
6	Wednesday + Thursday + Friday	Tuesday + Wednesday + Thursday + Friday
7	Tuesday	Monday + Tuesday
8	Wednesday	Tuesday + Wednesday
9	Friday + Monday	Thursday + Friday + Monday
10	Sunday	Friday
11	Saturday	Friday
12	Monday & Wednesday	Tuesday + Wednesday
13	Friday & Tuesday	Monday + Tuesday

I dont want to use Python in Alteryx.

Hence is it possible to derive such behavior using different tools?

Regards,

Ashish

[Yoshiro_Fujimori]

@AshishAgarwal 

Could you show us a sample input / output data to understand your requirement?

[KGT]

Take a look at the attached.

From a list of the dates for the year with the PH attached (Generate Rows), cut the Saturday/Sunday with a DateTime Formula (DateTimeFormat([Date],"%A")) and filter, then multi-row to tag the row before and after.

[aatalai]

@AshishAgarwal this blog might help

[dreldrel]

Maybe you could use a download tool to get Japan holiday from a public api, then use the date time function in the formula tool to calculate
https://holidayapi.com/countries/jp-13/2025

[AshishAgarwal]

I am trying to correct attached workflow to get proper date.

Sorry, above suggestion is not working for me.

[KGT]

You can enter this into the Multi-Row Formula (28) at the bottom of your canvas. I sorted by date before the Multi-row as well.

IF !IsNull([Holiday Dates])
THEN [Holiday Dates]
ELSEIF !IsNull([Row+1:Holiday Dates])
THEN "Day before " + ToString([Row+1:Holiday Dates])
ELSEIF !IsNull([Row-1:Holiday Dates])
THEN "Day after " + [Row-1:Holiday Dates]
ELSE Null()
ENDIF

Otherwise, you can put a record ID on before the join, take the joined data, add/minus one to the recordID and join again... but it's not as nice.

[AshishAgarwal]

@KGT I got below result with that logic when I run with date of 22nd Sept

However I wanted output only 22 Sept.

When I run with 19th Sept than I want result as 19, 18 & 17 sept only.

[KGT]

So you want the holiday, and the day before, but not the day after? So point 1 of your question, and not point 2? Just delete one of the ELSEIF clauses.

[Imaizumi]

I was not able to recreate Scenario 12 and 13, but I think from my workflow you can create your desired output for Result


I hope this will be helpful