I am trying to create a conditional part of my workflow to first query a database, then from that query, check if the output matches "A" in this case.
If that query from that database is = "A", then run workflow A. However, if that query matches "B", run the other workflow B.
I am having a hard time determining which tools to use in order to make this work. I've attached an example of what my workflow looks like. This workflow is workflow A, and there is a duplicate of this same exact workflow called workflow "B". The only difference between the two is the file name, and the query in the database. The workflow essentially hard codes s3 bucket name, adds a date and time to the file name, queries a database, and sends that to S3. The dynamic input is used to get the credentials from EPV and then uses those credentials in a string to connect to the database.
Anything helps! I am not able to use runner tool
My initial thoughts for a solution: epv -> dynamic input (to query database) -> filter? -> somehow connect to each container for workflow A and B
You could do this with Control Containers, however I haven't played with them heavily and so am not the best to ask.
How I would do this is make the workflow (A&B) into a macro and feed the filename and query in depending on the initial query.
Do you have any examples on control containers?
Also with the screen shot given, how would I make that into a macro if it doesn’t have any input or outputs needed?
apologies meant to send the reply here:
Do you have any examples on control containers?
Also with the screen shot given, how would I make that into a macro if it doesn’t have any input or outputs needed?
I'm not sure if I fully understand the setup here. I assumed that the AWS upload tool needed manual configuration, thus requiring the macro, but if the settings on it are taken from fields, then append the result of the query after the formula, and add a filter to decide the bucket/object depending on the result of the query.
If not, then the below may be needed.
The part that needs to change has to go into the macro. So, I am assuming the following:
Information on Control Containers can be found here: https://help.alteryx.com/current/en/designer/tools/developer/control-container-tool.html