Copy link to clipboard
Copied
I have a set of records that I need to sort by a random number. I have tried to use the RANDOM command by defining it as an Integer but that doesn't work, it returns a zero for all records. I am not sure what that command actually does so that might be the problem but nonetheless I would like help on how to assign numbers randomly to a found set of records. Thanks.
Copy link to clipboard
Copied
Are you talking about DataMerge?
What "random" command?
Copy link to clipboard
Copied
Well there isn't a Random function (which I really thought there was, stupid me). I was hoping there was a way to sort randomly on a field without involving Excel but if there isn't, I'll do it through DataMerge. Thank you!
Copy link to clipboard
Copied
Unfortunately, I still don't understand what you're talking about?
"Sort randomly" what?
Copy link to clipboard
Copied
Not sure if you are trying to randomize the order of pages (records) or generate a random number that will appear within the records. If the former, here is an online source that will shuffle pages in a PDF.