looping through dataset and output on record at time?

[mrnice]

Hi all,

I'm trying to have a flow which checks how many records are present in the dataset and outputs 1 record at time into a table until there are no more records. In my dataset each record has a unique ID

Is it possible to process one record at time?

[jdunkerley79 · Accepted solution]

You could do this using an iterative macro.

Use a sample tool to pick the first record, which you then process

Use another sample tool to skip the first record and use this as the loop for the iterative macro.

One issue is that there is a iteration limit on iterative macros which you may want to avoid.