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.
@JHAROHIT
you can create a batch macro or an iterative macro.
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.
@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.
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.