Hi I have a data here that I want to combine the values and convert it to a date format. See sample below:
I want to convert it to a date format but if the period falls into weekends,i want to move it one/two days to make it on weekdays. See sample below:
Month | Period | Year | Output 1 | Final expected output | Note |
July | 1st Period | 2022 | 7/15/2022 | 7/14/2022 | It was moved 1 day earlier since it falls on weekend |
July | 2nd Period | 2022 | 7/31/2022 | 7/31/2022 | Retain since weekday |
August | 1st Period | 2023 | 8/15/2023 | 8/15/2023 | Retain since weekday |
August | 2nd Period | 2023 | 8/31/2023 | 8/31/2023 | Retain since weekday |
How can I transform it in alteryx (Final expected output) . Can you help me with this one please?
Solved! Go to Solution.