Skip to main content
Participant
Apr 11, 2025 8:32 PM UTC
Question

Random sort of records

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.

4 replies

Robert at ID-Tasker
Legend
Apr 11, 2025 9:03 PM UTC

Are you talking about DataMerge?

 

What "random" command?

 

Translate
WI TervsAuthor
Participant
Apr 11, 2025 9:24 PM UTC

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!

Translate
Robert at ID-Tasker
Legend
Apr 11, 2025 9:27 PM UTC

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

 

"Sort randomly" what? 

 

 

Translate