3 Replies Latest reply: Apr 1, 2015 7:29 AM by Puttemans Johan RSS

    Assign random number

    Puttemans Johan

      Hi all,

       

      I have a table of around 750.000 lines, in which around 20 products are comprised over these lines. My issue is that the table is ordered on the product type, and so product 1 will be stting in the first lines, and product 20 in the last lines (I don't easily know how many lines each product has).

      My wish is to assign a random number (from 1 to 750.000) to each line in the table, so that when I order the table on the random number, all products are mixed. I've looked at Autonumber and Rand, but those don't seem to be helpful.

       

      Is there any other solution possible?

       

      Thanks