Hi All,
I am trying to create a macro with dynamic schema name in the output table. But I am not able to achieve that. attached is the screenshot of the macro. I am confused how to configure the input tool.
Help appreciated!!!
Hi @sjain71 ,
What are you looking to change exactly in your output tool? Is your goal to change the name of each tab?
Hi,
I want to change the connection string in the output dynamically.
I have 10 similar tables in different databases in SQL server. For eg, for the table orders I have CustomerA.Orders , Customer B.orders. Now I have to transform the data and load the data in 1 database (eg. Customer database ) which has 3 schemas (Customer A, Customer B, Customer C ) and three Tables CustomerA.orders, CustomerB.orders, and CustomerC.order.
Now I am able to read the data from all three customers using a macro but I am not able to insert data in three tables based on customers. The problem is I can change the connection string manually but the input sample will be different for different tables (orders, products, department). How can I build a reusable macro where input varies on the tables.
