I have a two simple schemas. Account has an id (Row Number) field. There is a dataset generated from this which is 10 rows so they are numbered 1 to 10.
Holding has a DatasetColumn referencing the id of the Account and I have specified “random” as the value choice. As such, I am expecting each new row to be associated with a random, valid account id.
I do not get random values. I get sequential values, starting with 1, going to 10, and restarting at 1 (they are the same every time, whether I Preview or generate a dataset). The only difference between selecting “random” vs “sequential” is that in the latter case the sequence restarts after 9 instead of 10.
Could someone please explain what I am doing wrong?