Record Count and Size for 50 Database in 1run

aragoncha

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!!

BrandonB

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-table-name-and-Column/m-p/44952/highlight/true#M17104