Read 15 SQL Tables all together in Alteryx Designer.

Question

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

Dhruv_001 · Answer

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

Dhruv_001 · Answer

Hi  @ Luke_C,

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

apathetichell · Answer

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.