AnsweredAssumed Answered

Filtering for unique values in a fixed number randomized list to get one of each

Question asked by JeffBroderick on Feb 24, 2015
Latest reply on Feb 25, 2015 by philmodjunk

Title

Filtering for unique values in a fixed number randomized list to get one of each

Post

Hello,

 

 

 

I have a group of 40 people who will meet with another member in that same group based on a random selection.

I created two tables with the same 40 people alphabetized and the same serial number ID from 0 to 39.

A looping Random script function on a List view layout creates the equivalent of:

John Doe                meets with        Peter Pepper

Peter Pepper          meets with         John Doe   etc.

Until the number of meetings is created.

What I need to do and haven't figured out is how do I create 40 meetings but each record that will show in the list view only has one each of the member ID or numbers 0 thru 39, since they are randomized.

I have the feeling that I need to do many, many loops and eliminate duplicates until there are only one of each.  I just don't know how to do the process to keep it going until there is actually one of each in each column of members.

Thanks,

 

Outcomes