Execute Different SQL Based on Day of Week

Alteryx pros, I need some help and I hope that you can point me in the right direction.

Problem: I have have two separate SQL statements that connect to the same data sources but contain different columns, etc and return different results. If it's Monday then i need SQL#1 to run; however, if its Tue-Fri then I need SQL#2 to run.

I know that I could break this up into 2 workflows and set each on a schedule related to its respective day in Gallery but I wanted to see if this could be done in a single flow so I didn't have to worry about managing separate flows.

I appreciate any suggestions.

Thank you!

Workflow

Dynamic Processing

Events

Accepted answers

Harbinger

I would leverage the dynamic input and update the columns to pull from SQL based on the day of the week.

Here is what it would look like with a dynamic input tool! you'll need to configure the input data source template to the following format: SELECT COLUMNSTOREPLACE FROM theTableYoureQuerying WHERE yourconditions.