making a random list

[tommypmadison]

Hello,

I have a group of records that needs to be searched to find the records meeting certain criteria...from the found set that meets the criteria, I need to do several random samples of the list, extracting 7 unique records each time. Is there a way to use random to get each unique set of seven records from the found set ( the found set is usually between 55 - 70 records....

Thanks,

Tom

[LaRetta]

[color:blue]I have a group of records that needs to be searched to find the records meeting certain criteria...

Alright, see attached demo for ideas. The User would enter the original find criteria (or you can use Find Request for it) but let's assume it is User specified and the criteria is Age = 22.

[color:blue]from the found set that meets the criteria, I need to do several random samples of the list, extracting 7 unique records each time.

The find produces 14 records with Age = 22. This is truly not enough for a good random sample but it should give you the approach. System asks you how many random records to produce. You can 1) re-use the same Find (user specified) by script-step 'Modify Last Find', 2) Split the random portion from the main script so it can keep finding different '7' records for the same set.

Does this move you forward a bit? If not, provide more specifics and we'll work through it.

LaRetta :wink2:

RandomUniqueSet.zip

Edited August 12, 2007 by Guest
I updated the demo with proper comments

[tommypmadison]

Thanks,

that definitely gets me on the right course!!

Thanks,

Tom