Randomize rows from a datatable

[#1]

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 ! 

[#2 · Accepted solution]

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

[#3]

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 !

[#4]

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.

[#5]

I haven't seen similar Wish list item, so here it is : Randomize rows from a datatable 

Thanks for the help @jthi. 

[#6]

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:
Sort data table + add rows + concatenate -- make it possible