This might actually be related to Limits results to # available?, though it just came up in a completely different context.
Is it possible to use random but avoid duplicates (at least, until necessary)?
The only way to avoid duplicates is to use the “sequential” option on Custom List and Dataset Column fields. It will iterate through the list until it hits the end, then restart at the beginning. So if your list is long enough, you won’t get repeats.
Hi
I understand your answer, but if you want to generate a random sequence (from a dataset field for example) but with term unicity, the sequential approach will not work because the generated sequence will always have the same terms order.
Thanks and regards
I believe adding a “Random - No Repeats” option to Custom List and Dataset Column fields would be a useful feature. That way you could ensure uniqueness without having to use Sequential. It could start to repeat only once all values in the list have been used once.
6 Likes