migrate tables to other database defined in a flat file

abhidgs

Hi All,

I am very new to the alteryx.

I have received a flat file which contains schema and table name .

I need to migrate all the table after reading input from one db to other.

Schema is same for both the databases.

Table name requires modification like for source db need to add 'dbo.' before table name.

I have prepared the attached macro to modify the name changes:

Please could you help me the workflow for db?

Any other way to method for this completed design?

Rename.yxmc

Dynamic Processing

Accepted answers

AbhilashR

@abhidgs - you could create the individual select queries using the formula tool and pass it into a dynamic input tool (which will query the data from source system), and write to the destination system using output tool. In my example I pass the query into a batch macro, which reads and writes one sql at a time, which should be able to get you close to what you are looking for.

dbReadWrite.yxzp

All comments

AbhilashR

dbReadWrite.yxzp

abhidgs

Thanks @AbhilashR .

I have used the concept from proposed solution and designed workflow.

Puneet13

Hi Abhilash the below concept is not fruitful, it is not giving drop down of PDW in macro section, could you please suggest? I need to drop multiple table in different database, please help here

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703