In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Retain Table tool settings with dynamic in-db input tool

revanthavi14
5 - Atom

My workflow passes a parameter to sql query’s where clause using Text Box - Update macro and my sql query is stored in Text Input tool and passed to the dynamic in-db tool to execute the query. The query results are fed to the Table Tool where I’m doing some formatting. Since I’m using the dynamic in-db to execute the query, my table formatting is lost after I execute my workflow. How do I retain my Table Tool formatting here or is there any work around for this? I just need one parameter in the query where the user enters an ID. 

2 REPLIES 2
alexnajm
19 - Altair
19 - Altair

So currently you are doing Text Box --> Dynamic Input In-DB --> Data Stream Out --> Table tool? If so, that should work since the formatting settings are all done in that Table tool.

apathetichell
20 - Arcturus

Did you have a series of customized settings in your table tool - which are now being lost? Did you copy the table tool from somewhere?

Labels
Top Solution Authors