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? 

[AbhilashR · Accepted solution]

@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. 

[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