I have a set of steps that I want to process in Salesforce Marketing Cloud, but I'd like to make it easier for my users. I have a set of steps I want to run if a column is "True" and a different set of steps that I want to run if a condition is "False". There are multiple SQL queries/steps and they are all setup, but I wanted to create a single "easy button" that would allow for users to change the "True" or "False" value in my data table on a single record and have it run the other processes.
Here is an example:
Master Table: Row 1: True or False
Other tables IF TRUE: Select SubscriberKey, Email, Value= 'Yes' From Contact_Salesforce
IF FALSE: Select SubscriberKey, Email, Value= 'No' FROM Contact_Salesforce
It is actually more complex than this, but I wanted to make it simpler. Basically, I'd love to run certain SQL queries in an automation if that master table is true and not if it is false (do nothing) and vice versa for the other steps.
Is there a way to do this, or should I just have them do the "run once" on the first set of steps if the condition is true and run the other set of steps as a "run once" if it is false?