topic Re: Randomize rows from a datatable in Discussions

Randomize rows from a datatable

Victor_G — Thu, 20 Mar 2025 10:42:29 GMT

Hi dear Community,

I have searched the Community for this question but was not able to find an answer.

Due to specific objectives, I created a DoE using first a D-Optimal approach (24 rows) and then augmenting it with Space-Filling augmentation (adding 16 rows). The problem I'm facing is that rows are not randomized for the entire design, you can clearly see the initial rows are from D-Optimal design and the next ones are from Space-Filling augmentation :

Is there an option to randomize rows once the complete design is created, to mix rows from D-Optimal and from Space-Filling ?

Thanks in advance for any inputs,

EDIT : I might have found a workaround using an "ID" column to identify experiments, and using "Shuffle without replacement" to randomize order of the experiments. But if something more practical exists, that would be easier !

Re: Randomize rows from a datatable

jthi — Thu, 20 Mar 2025 10:44:24 GMT

I think one option could be to create subset with sampling rate of 1

Re: Randomize rows from a datatable

Victor_G — Thu, 20 Mar 2025 10:51:05 GMT

Thanks a lot @jthi !
Works like a charm and it's a lot faster than what I intended to use (creating an ID column, then a shuffle version of this ID on a new table, and then joining the info from the factors columns of the first table to the new shuffled table by matching the ID columns).

Maybe a new option could be added in the Augment design platform to enable randomization of the entire design ?

Many thanks !

Re: Randomize rows from a datatable

jthi — Thu, 20 Mar 2025 10:54:41 GMT

Yeah, I think there should be possibility to randomize JMP table in place (maybe with some extra options?). It could be under Table or Rows menu. So maybe we should create wish list item about it UNLESS there is already one.

Re: Randomize rows from a datatable

Victor_G — Fri, 21 Mar 2025 15:31:09 GMT

I haven't seen similar Wish list item, so here it is :

Thanks for the help @jthi.

Re: Randomize rows from a datatable

hogi — Fri, 21 Mar 2025 16:26:25 GMT

another approach:

add a column with random number
sort by this column
delete the column

Either via Subset of via the additional column - it's super easy to create an AddIn to make this functionality available from the main menu.

Not so easy:
make sort possible if there is a (linked) subset: