Truly Automating Workflows - HELP

Question

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

MonthDayBus DayTask in Alteryx 913FridayJob A916MondayJob A917TuesdayJob A918WednesdayJob A919ThursdayJob A920FridayJob A923MondayJob B    1014MondayJob A1015TuesdayJob A1016WednesdayJob A1017ThursdayJob A1018FridayJob A1021MondayJob A1022TuesdayJob B    1113WednesdayJob A1114ThursdayJob A1115FridayJob A1118MondayJob A1119TuesdayJob A1120WednesdayJob A1121ThursdayJob B1122FridayJob B

Tommy_Alterax · Answer

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

apathetichell · Answer

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.