Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Action Tools not Updating Tools within a Control Containers

mattjacobs
7 - Meteor

I have a batch macro that passes values created in a workflow via a Formula Tool.  When this workflow run with the tools in the macro in a Control Container, the Action Tools have no effect on the query which is inside a Connect In-DB tool.  The macro has multiple Control Containers to control the sequence that the multiple queries run.  I tested the macro by taking one of the queries out of the Control Container and all updates where made.

 

So, I have these questions:

1. Is there some sort of explicit prohibition to Action Tools updating tools inside a Control Container?

2. Does some else also seen this and have a way to make this work?

11 REPLIES 11
alexnajm
18 - Pollux
18 - Pollux

There should not be - can you show us your configurations?

mattjacobs
7 - Meteor

@alexnajm Can you clarify what it is you would like me to share?  Thank you.

alexnajm
18 - Pollux
18 - Pollux

@mattjacobs ideally your workflow, but otherwise screenshots of your tool configurations

mattjacobs
7 - Meteor

Unfortunately I cannot post the full workflow, just the previously shared screen shot (proprietary code).  I have attached the config screen shots.

alexnajm
18 - Pollux
18 - Pollux

@mattjacobs apologies, but we'll need screenshots of the tool configurations (i.e. the Action tool) - otherwise I am trying to build a workflow to illustrate that Action tools shouldn't be affected by Control Containers

mattjacobs
7 - Meteor

I added a screen shot of an Action Tool, they all are doing the same basic thing, changing a specific string, either within a query in a Connect In-DB tool or the table name in the Write In-DB tool.

alexnajm
18 - Pollux
18 - Pollux

Thank you for the screenshot - that looks correct to me. My quick batch macro to update a Connect In-DB tool worked just fine for me and looks very similar to your screenshot

 

Can you use the Debug and see if the value changes? You can input a test value and see if it replaces the 2301 in your screenshot: Debug Workflow

mattjacobs
7 - Meteor

Thank you for the suggestion.  It seems that Debug does not work yet in macros with Control Containers (see screen shot).  Also seems you are using a newer version of Designer, I'm on 2024.1, so not sure if that is something that is fixed in a newer version.

alexnajm
18 - Pollux
18 - Pollux

That's right - I hated that conflict in 2024.1. It does get fixed in newer versions!

 

Here are screenshots in a row showing that action tools can update in-db tools in control containers 👍

Labels
Top Solution Authors