Free Trial

Alteryx Designer Desktop Discussions

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

Record Count and Size for 50 Database in 1run

aragoncha
5 - Atom

Hello all, 

Thanks ahead to all supporting and using this tool as I am hooked... 

 

I am looking for a tool or suggestion here..  I can do record count from summarize or In-db summarize tools -- But, this effort is one database at one time.  What I am looking for is a way to say get 50 database at one time (one run)  and get the name of database/ record count / size (maybe) in output to excel. 

 

Thanks for suggestions!!

1 REPLY 1
BrandonB
Alteryx
Alteryx

You may want to use a dynamic input tool. This can be used to feed in a list of table names to switch out in your query. You can see an example of this here:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Configure-Dynamic-Input-tool-to-accept...

Labels
Top Solution Authors