Truly Automating Workflows - HELP

[Tommy_Alterax]

Hi Guys,

I am currently on Alx version 2020 as our server is 2020 and we are upgrading to Alx v 2023 imminently

I am running workflows  to a business day calendar, see the table below for a flavor

Where you see "Task in Alteryx" - and a Job - I literally tick a box in Alx 2020 (from the Gallery - Box relates to Job A or Job B) to open a container , process data and write to a SQL DB. The data processing is done different depending on the Job if A or B - thats the key -  we are writing to the same SQL DB for Job A and Job B  - so should never tick both Box A and Box B 

I would like to move away from me having to tick a box and schedule the workflow to run - Say by looking at a  Datetimenow value and executing to the Business Day Calendar for a full 12 months

I am wondering if I had a full years worth of dates and what Job is to be run - Could I automate this completely in Alteryx - I've heard control containers etc in 2023 (but do not know much about them) - Other suggestions also

Month	Day	Bus Day	Task in Alteryx
9	13	Friday	Job A
9	16	Monday	Job A
9	17	Tuesday	Job A
9	18	Wednesday	Job A
9	19	Thursday	Job A
9	20	Friday	Job A
9	23	Monday	Job B
10	14	Monday	Job A
10	15	Tuesday	Job A
10	16	Wednesday	Job A
10	17	Thursday	Job A
10	18	Friday	Job A
10	21	Monday	Job A
10	22	Tuesday	Job B
11	13	Wednesday	Job A
11	14	Thursday	Job A
11	15	Friday	Job A
11	18	Monday	Job A
11	19	Tuesday	Job A
11	20	Wednesday	Job A
11	21	Thursday	Job B
11	22	Friday	Job B

[apathetichell]

Sure - you wouldn't need to re-engineer this into a control containers situation -> just turn your current outer app into a macro- create your day/match/run matrix as a new outer app - > feed this into your current outerapp which is now a macro. This assumes you know the datetime for your server and your server datetime matches your days - and you've built the correct logic.

[Tommy_Alterax]

Hi , thanks for the response - I am not great with Macros - I think I understand what you are suggesting (not macro part) - Some kind of filter with a true false for each out come ? Is that correct

However, If I was to introduce a 3rd Job (I tried to keep this out of my initial question) How would I manage that in the filter