Batch Macro by Record ID Question

[brperkins2]

I am trying to build a batch macro by record id. Please see below details of the batch macro.

• Alteryx Record ID Batch Macro : The input to this macro is a text input tool with record id from and to columns. The from column has record id 1 to 1,000,000 and is in 1 million record increments up to 9 million records. I want this to run a loop for record id partition and then append / union the output together or seperately to be unioned up later into a master alteryx database file.

How can I build a batch macro to input two columns to replace in each macro run? I want to replace there where clause in the query to where the record ids are within each partition.
Please see attached clean example. Thank you.

[OTrieger]

@brperkins2 

I still do not understand what you are trying to do.

[brperkins2 · Accepted solution]

I was trying to build a batch macro to run a query where the record id is between two values specified in the text input d. i had to  use two control parameters in the beginning. i labeled them as min1, max1, mapped them in the macro input and replaced the SQL code with these values. It is working now.

ataset. I got it working. 

[OTrieger]

Very well done!!! 😁