Jump to content

Selecting Records At Random


This topic is 4765 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a table that contains 397 assessment questions and answers. Is there a way of pulling out a predetermined number of records at random? Would the random function be appropriate here?

Link to comment
Share on other sites

I would define an unstored calculation field (result is Number) = Random.

Thanks for the reply comment. So the first step for 40 records as an example would be (40)= Random? I suspect not because this returns a value of zero across all records.

Link to comment
Share on other sites

go to record number N+1 and

Sorted the random calculation. If N = 40, what's the best way to go to the 41st record now that they are in random order?

omit multiple records [Get (FoundCount) - N].

Do I use the Get(FoundCount) - N in the specify box of Omit All Records script step?

Link to comment
Share on other sites

Works a treat, thank you very much!

I was expecting it to pull the same 40 records out every time I run the script but I'm delighted that it doesn't. That can only mean that the random value must be changing in each record, at what point does it do that?

Link to comment
Share on other sites

This topic is 4765 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.