Dynamic Select and Insert

[GayatriPanigrahi]

Hi Team,

I have two database (1- XDatabase, 2-YDatabase) i need to read multiple tables from XDatabase which has different structure and write back to YDatabase as tablename_1.

I have attached require model. 

Logic to create:

1) Can store list of table name in excelfile/text input

1) SELECT ColumnName FROM @XDatabase.tablename (variable)

2) INSERT INTO @YDatabase.tablename_1

Can anybody suggest how to achieve this in Alteryx.

[afv2688]

Hello @GayatriPanigrahi,

You cannot do achieve what you want using IN-Database tools. What you want to do would require using batch macros and that cannot be done using tose tools since alteryx doesnt allow it. You could indeed access the data using standard inputs, group the data together and upload it to your database.

Regards

[GayatriPanigrahi]

Hi @afv2688 ,

Could you please share any sample workflow or macro.

[afv2688 · Accepted solution]

Hello @GayatriPanigrahi ,

This is a small example that illustrates how to do it. I just used a text input instead of a real connection name as I cannot share those.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards