WINDOWS > JMP 17.2 > Scripting > Ordered Differences Report Capture as a Matrix > HELP

[#1]

Hi JMP Community,

I am working on an automation script to analyze a large dataset. I want to capture the Ordered Differences Report for many variables.  To speed up the analysis, I traditionally capture the output of the analysis platform using matrices. However, for this particular application, the order of the output (rows) depends on the test results (see below).

Hence, the order of the comparison may change for each variable.

Is there an approach to lock the order of the rows in this table to guarantee the consistent capture of the result values as a matrix?

If not, how would you approach this problem (e.g., capture the result TableBox as a Table > Sort on both "Level" and "-Level" > Capture as a Matrix)?

Thank you for your input.

Best regards,

TS

[#2 · Accepted solution]

I would most likely do what you are suggesting: turn the table box into table and sort by two columns. You can then choose what you wish to do: collect all results into the same table, start building some other method of result collection (associative array + matrix), ...