Want to different rows in differet iteration

New Altair Community Member
Updated by Jocelyn
Lets say I have a dataset containing 10 rows. I want do iteration over these rows. In first iteration I want first row as output, in the second iteration I want first two rows as output, in third iteration first three rows and so on. How can i achieve this.
Find more posts tagged with
Sort by:
1 - 1 of
11

MartinLiebig

Accepted Answer
Updated by MartinLiebig
Hi,
i strongly advice to use proper set operations to do the transformation. Especially if your data set is not 10, but 10000 rows+.
But you can use Generate ID, then Group Into Collection with this id and then Loop Collection to iterate over each row. A simple Loop examples with a Filter Example Range inside would also do it, but is slower than the Group Collection approac.
Best,
Martin
Sort by:
1 - 1 of
11


Accepted Answer
Updated by MartinLiebig
Hi,
i strongly advice to use proper set operations to do the transformation. Especially if your data set is not 10, but 10000 rows+.
But you can use Generate ID, then Group Into Collection with this id and then Loop Collection to iterate over each row. A simple Loop examples with a Filter Example Range inside would also do it, but is slower than the Group Collection approac.
Best,
Martin