Sending Email with Conditions

HI Alteryx Community,

This email is sent weekly on Fridays. However, if Friday is a holiday, it should be automatically sent on Thursday. I have attached a sample workflow, but I'm unable to find a solution. I hope you can assist me in finding a solution.

Additionally, I have attached a file containing the list of holidays.

I look forward to your response.

Kamen

US HolidaysT.xlsx

Sending Email with Conditions.yxmd

Accepted answers

KamenRider

Hi @aatalai

Not quite sure about this workflow but it seems that there are still no data for today Friday.

no data for Friday.JPG

I am still working to understand it.

Kamen

KamenRider

Hi Alteryx Community, - @aatalai @binu_acs @Qiu

Please share your feedback on the attached workflow. The aim is to send the email by Friday, but if it's a US holiday, it will be automatically sent on Thursday instead. I believe there won't be any US holidays on both Thursday and Friday, so this approach should work well.

Thursday and Friday Email Condition.JPG

Kindly revised my workflow to make it more simple and have captured the requirements.

Looking forward for your response,

Kamen

Thursday and Friday Email Condition_TEST.yxmd

All comments

aatalai

@KamenRider updated your work flow, if the holiday is on a Friday, what is the previous day, join the data with actual date and the date for the coming Friday and appending the new date if relevant and then filtering. I've attache a workflow, please let me know how you get on