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
17 - Castor
17 - Castor

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