Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

JHAROHIT
7 - Meteor

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.

4 REPLIES 4
Raj
16 - Nebula

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

JHAROHIT
7 - Meteor

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
16 - Nebula

@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
17 - Castor

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.

Sapna Gupta
Labels