Sending Email with Conditions

[KamenRider]

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

[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

[KamenRider]

HI @aatalai 

Is the send out date always "NULL"? Try turning tomorrow as holiday and the "send out date" is still NULL.

Please advise,

Kamen

[Carlithian]

can you attach your tweaked version ? :)

[aatalai]

@KamenRider no it will be non null when the holiday falls on a Friday and a new date (Thursday) needs to be sent on

[KamenRider · Accepted solution]

Hi @aatalai 

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

 

I am still working to understand it. 

Kamen

[KamenRider · Accepted solution]

Hi Alteryx Community, - @aatalai  @binuacs @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.

 

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

Looking forward for your response,

Kamen

[aatalai]

@KamenRider in regards to your question you need to look at the true output of the filter