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 SceanrioHolidayResult1MondayFriday + Monday2Monday + TuesdayFriday + Monday + Tuesday 3FridayThursday + Friday4Thursday + FridayWednesday + Thursday + Friday5Monday + Tuesday + WednesdayFriday + Monday + Tuesday + Wednesday6Wednesday + Thursday + FridayTuesday + Wednesday + Thursday + Friday7TuesdayMonday + Tuesday8WednesdayTuesday + Wednesday9Friday + MondayThursday + Friday + Monday10SundayFriday11SaturdayFriday12Monday & WednesdayTuesday + Wednesday13Friday & TuesdayMonday + Tuesday I dont want to use Python in Alteryx. Hence is it possible to derive such behavior using different tools? Regards, Ashish

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

Developer

Designer Cloud

Date Time

Common Use Cases

Accepted answers

All comments

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.

PH days around.yxmd

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.

Holiday Dates_Ashish.yxmd

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
Find Holiday dates and period.png

I hope this will be helpful

Find Holiday Dates and Peiod.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335