Create a table with random values

Hi all,

I have a problem, where I dont know, how to realize. I want to fill a table (for example the table has 3 rows and 1 column) with 3 random values between 1 and 5. This is no problem, but I want, that while one value exists, that another value should be created. For example:

Row-Number Value
1 5
2 2
3 5

I want, that row number 3 should be 1, 3 or 4.

Does anybody know how to solve this problem? Thanks,

Michael

Hi,

What you need to do is create a random number between 1 and 5, then check it
against already created random numbers.
If the number already exist create a new number and repeat the check,
if the number does not exist save it.

Lars-Olof

Hi Lars-Olof,

thanks for your fast reply. My problem is, to check it against. I have no idea how to do.

I tried the following:

intarray myarray = makearray(5);
int CounterMyArray = 1;

for (int iCounter = 1; iCounter <= 5; iCounter ++)
{
int iRandomValue = duniform(1,5);
while (CounterMyArray <= 5)
{
if (myarray[CounterMyArray] == iRandomValue)
{iRandomValue = duniform(1,5);
CounterMyArray = 1;}
else
{CounterMyArray = CounterMyArray + 1;}
}
CounterMyArray = 1;

But this small code doesn' work. I know, it is not an table, but I thought, that an Array could do the same...

Hi,

Try this code.

intarray myarray = makearray(5);
int found;
for (int iCounter = 1; iCounter <= 5; iCounter ++)
{
    found=1;
    while (found==1)
    {
        int iRandomValue = duniform(1,5);
        found=0;
        for (int index=1; index<=iCounter; index++)
        {
            if (myarray[index] == iRandomValue)
                found=1;
        }
        if (found==0)
            myarray[iCounter] = iRandomValue;
    } 
}

Lars-Olof

Hi,

Here is another solution where I use GlobalTable.
What I do is set the table size to number of random numbers I want, then I populate the table with values.

1. Now I create a random number between 1 and the size of the table
2. Read out the value in the table.
3. Assign the value to an array
4. Remove the row from the table.
5. Now I start over with 1 until all my random numbers is generated.

treenode table=reftable("Table1");
intarray myarray = makearray(5);
settablesize(table,5,1,1,1);
for (int index=1; index<=gettablerows(table); index++)
    settablenum(table,index,1,index);
for (index=1; index<=5; index++)
{
    int rows=gettablerows(table);
    int randValue=duniform(1,rows);
    myarray[index]=gettablenum(table,randValue,1);
    deletetablerow(table,randValue);
}

Need more information, let me know.

Lars-Olof

Hi Lars-Olof,

first I want to say, thanks for your help. Two solutions in this short time is more than I hoped before.

It helps me, to understand, what I have to do. The idea with an found variable is very helpful for my problem.

I tried your first Code and first it works realy fine. But after a small time Flexsim crashed.

Attached you see a Queue. OnReset I write the Array-Values into the OutputConsole. I press the Reset Button for maybe 3 to 5 times and then Flexsim crashed. Do you have an idea why?

Hi,

I have the same problem, for me Flexsim locks up after pressing 3 to 4 times on reset.
When I added this code the problem disappeared:

for (int index1=1; index1<=5; index1++)
    myarray[index1]=0;

You need to add the code before the for-loop.

It looks like Flexsim reuse the array in the same session and what happens is that next time we call OnReset.
The array already exist with values from the last time and when we do the check we
are going in a loop that never ends.
Therefor we need to put all the values in the array to 0 or another value that we
never will be generating.

The first code I posted will take longer and longer time to run if you increase the number of
random number you want to generate. There is a bigger chance that you will going into a loop that never ends
or take long time to finish.

The second code will be never go in to a loop that never ends or take long time, but the
draw back is that you need to use a table.

Hope this help you.

Lars-Olof

Hi Lars-Olof,

many thanks, it works very good . That was, what I need