Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
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.
Solved! Go to 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.
