Currency Holiday Output

[clarrock]

Hi,

Situation 1

How to create an output such that if its a DKK ccy holiday today (assume today is 27th June) then the start date and end date comes as below - ie No

Settle cycle	Ccy	Start Date	End Date
T1	DKK	No	No

Situation 2

If theres say a MXN and DKK holiday tomorrow (assume tomorrow is 28th Jun) then the start and end Date outputs as below : since MXN has a T0 cycle its today to day after tomorrow (next normal day (non-public holiday) - if theres a holiday the next day as well then it shd skip that day as well)

since DKK has a T1 cycle then its day after tomorrow (not a DKK public holiday) to the next day (not a DKK public holiday).

Settle cycle	Ccy	Start Date	End Date
T0	MXN	27-Jun-2022	29-Jun-2022
T1	DKK	29-Jun-2022	30-Jun-2022

Start and End Dates shd skip Saturdays and Sundays

Is this possible on Alteryx? Attached the holiday calendar.

[DanM]

@clarrock 

I'm making the assumptions that you're using DateTime fields and not String fields for this suggestion. You could join your calendar data with the data you are working with (again assuming) and write conditional statements to create the time frames by using the date time add function. Something like, if column 1 equals column 2 then datetimeaddfunction depending on the situation. You may also have to write a conditional statement for each situation you mentioned and any other that may cause your dates to change.

I'm not familiar with the acronyms you are using and I would suggest not using acronyms when posting your questions as users may not understand them without effort and may shy away from assisting. 

Suggested help - https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

and https://community.alteryx.com/t5/Interactive-Lessons/DateTime-Functions/ta-p/98952

[MatthewO]

@clarrock attached is an example of how you can approach this using Alteryx. I hope this is helpful!

[clarrock]

@MatthewO Thanks for sharing the worflow
I looking for an output like below :

Today is 30th Juneand as per the file tomorrow it is a CAD holiday which has a T0 settlement and HKD which has a T1 settlement

(to explain T0 and T1 in a situation with no holidays, T0 means today start to tomorrow end and T1 means tomorrow start to day after tomorrow end)

Alteryx output shd be below for 30th June run :

Ccy	Settle Cycle	Start Date	End Date
CAD	T0	2022-06-30	2022-07-04
HKD	T1	2022-07-04	2022-07-05

Tomorrow when i run i,e on 1st July the output would be below :

Ccy	Settle Cycle	Start Date	End Date
CAD	T0	No	No*
HKD	T1	No	No
USD	T0	2022-07-01	2022-07-05**
CZK	T1	2022-07-04	2022-07-06***

*No as its a holiday (cycle doesnt matter)

**04th is a USD holiday

***05th is a CZK holiday as in the file

Is this possible on Alteryx?