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?