Skip to main content
Participant
April 11, 2025
Question

Random sort of records

  • April 11, 2025
  • 1 reply
  • 272 views

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.

1 reply

Robert at ID-Tasker
Legend
April 11, 2025

Are you talking about DataMerge?

 

What "random" command?

 

WI TervsAuthor
Participant
April 11, 2025

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!

Robert at ID-Tasker
Legend
April 11, 2025

Unfortunately, I still don't understand what you're talking about? 

 

"Sort randomly" what?