Run Macro 1 Row of Data at a Time

Question

I have a standard macro that I want to run for each row of data in my Input but only after the previous row has finished processing in the macro. The macro runs a batch script that kicks off an internal process, writes data to a SQL database, then creates a large CSV file. Alteryx seems to be running all rows simultaneously which won't work as I need resources freed before processing the next row of data.

Screenshot of workflow with 2 rows to be processed

Macro for processing row of data

JosephSerpis · Accepted Answer

Hi @cmbarnett it sounds like you would need to create a batch macro then. This would run the first row from your input then the second row. From the picture of your standard macro you wouldn't need to change much to turn it into a batch macro.