Dynamic Select and Insert

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.

MultipleInput.xlsx

Workflow

Transformation

Expression

Accepted answers

afv2688

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

variables_db.yxmd

macro_db.yxmc

All comments

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703