Read 15 SQL Tables all together in Alteryx Designer.

[Dhruv_001]

I want to read 15-20 tables from my SQL Server to Alteryx Designer. 

I don't want to add 15 DB Input tool to read the tables in Alteryx Designer.  I have a Date_Created field in all the tables, I want my Alteryx to read the latest date_created file from the tables.

Thanks

[Luke_C]

Hi @Dhruv_001 

You can use a dynamic input tool. If you have a list of the table names you can configure the dynamic input to be something like "Select Max latest_created from xyz" and have the tool sub in each table name. There will be an option to replace specific text (table name) based on a field. 

https://help.alteryx.com/20231/designer/dynamic-input-tool

[apathetichell]

two column list of database name and query.

batch macro

text input tool.

control-parameter to action tool to text input tool (*2). -map the two columns to the text input tool.

dynamic input in-db. map your query and connection to dynamic input-in-db.

data-stream out.

macro out.

configure macro to union by name.

connect your original listing to your new macro. hit run.

[Dhruv_001]

Hi  @ Luke_C,

Is it possible, I want to call specific fields from each tables? What can be the best approach?

[Dhruv_001]

Do we have any sample or any workflow which I can go through it?