Welcome to the JMP User Community!

Latest Discussions

• How to transform matrix into 2D data table?

  Input: Summarize(g=by(age, sex), c=count()); show(g, c); output: g:{{"12", "12", "13", "13", "14", "14", "15", "15", "16", "16", "17", "17"}, {"F", "M", "F", "M", "F", "M", "F", "M", "F", "M", "F", "M"}} c:[5,3,3,4,5,7,2,5,2,1,1,2] How to make the result into a data table with column as sex and row as age? Like pivot table?

  

  Discussions |

  Apr 1, 2021 1:33 PM

  3577 views | 4 replies

• Moving text/numedit boxes into tab container without losing formatting/spacing - App Builder

  I have built an app using the JMP Application border. I have text boxes, numedit boxes, and buttons arranged in a format I wish to retain. I am attempting to move what I already have into a paged tab container. When I do so, it messes up all of the spacing and formatting of the individual text/numedit boxes. Is there a way to move them all into a tab page container without losing all the formattin...

  rickr135

  Discussions |

  Apr 1, 2021 8:55 AM

  1651 views | 2 replies

• Recording and recovering metadata in a table

  I have a stacked data table with three columns that contain strings and another numeric.  A: unique identifierB: textC: text As, Bs, Cs, Values-----A1, B1, C1, value11A1, B1, C1, value12A1, B1, C1, value13A2, B2, C2, value21A2, B2, C2, value22A2, B2, C2, value23 Right now, I am creating a concatenated column name with the form "A (B) [C]" which I split to have the final table like so: A1 (B1) [C1]...

  FN

  Discussions |

  Apr 1, 2021 8:36 AM

  1628 views | 5 replies

• Using JSL script to sort a column in a data table using List Check or Value Order property

  Hi all, I'd like to use the List Check feature or the Value Order column property to custom sort a column in a datatable. This data table is created from a subset of another data table, but I am unable to get the property to custom sort the values in the data table. The relevant commands I'm using is as listed below:     dt_summary_table = (Data Table( "Name of table" )) << Make Into Data Table; /...

  JmpStatistician

  Discussions |

  Apr 1, 2021 5:00 AM

  2612 views | 3 replies

• How to subset a data table based on column value

  Hello!  I have a large JMP file which contains the stability testing results for many (>75 product lots).  I want to create a script to subset the rows of testing data based on the column value (i.e. the lot number) while only including certain test result columns from the file. I am fairly new to JMP and JMP scripting, but I have managed to put together the following script: Data Table( "Stabilit...

  KKlear

  Discussions |

  Mar 31, 2021 3:41 PM

  4843 views | 4 replies