Run a loop in Alteryx (Data is fetched in multiples of 100 )

[JHAROHIT]

Hi ,

I have a use-case where in an internal system allows to fetch only 100 records at once (there is no identifier while fetching but there is a unique ID which can be utilized). 

Currently there are 36K records in the system but in the near future it is going to be around 1 million records.

My alteryx workflow is able to fetch first 100 records , how do I customize this to fetch all records in multiples of 100 and append to the output file.

I am sure about the possibility of doing it as the team is utilizing a python code to achieve the same result but not sure about ways to do it in Alteryx.

Appreciate your help in advance.

Regards,

Rohit Jha.

[Raj]

@JHAROHIT 
you can create a batch macro or an iterative macro.

[JHAROHIT]

Thank you, Raj.

I havent created a iterative macro before , tried to go through a few articles but couldnt understand exactly the paramters to be passed, 

Do you suggest any basic articles or sample tutorials for the same ?

I did try to to configure it for my workflow but it is only running once.

Regards,

Rohit Jha.

[Raj]

@JHAROHIT 
you can assign the reference number per 100 records
for example first 100 records as 1 next 100 records as 2 and so on

in the macro you can assign the filter using reference number and engine.iteration number
just for information engine.iteration number starts from 0

hope this helps
mark done if solved.

[grazitti_sapna · Accepted solution]

Hi,

Please refer to the link below to learn how to use the iterative macro. This interactive video provides step-by-step guidance to help you get started:-

If you have different requirements or need specific assistance, feel free to let me know.
https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925

Let me know if your requirement is something else or having any specific requirement.