Is it possible to get get the number of times we have iterated through a sequence?

#1

if I had the dataset: (a,b,c)
which would be iterated over an arbitrary number of times, how could I get the iteration number?

itr,data
0,a
0,b
0,c
1,a
1,b
1,c
...
n,a
n,b
n,c
#2

There isn’t a way to get it directly but you could add a row number field and use a formula like row_num % list_length

#3

any way of getting list_length without hardcoding (it is being stored in a dataset)?

#4

solved:


cartesian Dataset column between the desired dataset and a list of numbers (I made mine 0-20000).