Iterative macro

[avuong6]

Trying to automate my process with iterative macro:

right now it runs sql to look up a table and send output to sheet

I want to connect this process to a worksheet that contains the names of the tables, change the table name referenced in the sql, output the data each time the table name is referenced.

added a macro input and set it up to pull from excel sheet with table names. 

how to connect macro tool to database sql so that it can change the names for each iteration?

[geraldo]

hi!

an example with macro.

 ymxd excel table names

yxmc macro with sql statement replace.

[avuong6]

@geraldo 

thanks for the guidance. i setup things up like you example, when i right click i cant seem to convert to macro:

When i add the macro tool, it doesnt connect to anything on the workflow. Where am i going wrong?

[geraldo]

Hi,

I made an example using batch macro and not iterative macro. I am using the control parameter tool to receive the name of the table that is in excel

There are 2 flows, one yxmd and the other yxmc, which is the macro that allows you to change the tools. you will not follow change if this is not the way I made an example.

[avuong6]

@geraldo 

ok, i was able to modify my workflow following your example and it works, but i really need it to make 2 concurrent updates to the sql code:

in 1st iteration, it would update items in yellow

in 2nd iteration, it would update items in green

etc

i tried putting in 2 action tools, but it didnt work. any ideas on how to make this work?

[geraldo]

@avuong6 

I don't know how your sql is. I'll do an example update.
sql example

select Hireachy from dh_data_element

Update value in Hierarchy

leave only the text you want to replace

repeat this process in the other action update value tool.