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.
