In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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
18 - Pollux
18 - Pollux

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
19 - Altair

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