Welcome to the JMP User Community!

Latest Discussions

• Equivalent of get rows where for multiple arrays

  Hello,  This seems like a quite basic question, but I'm likely using the wrong search terms because I haven't found a good answer. I have a script where initially I was just making a list of strings (file paths) and could use them in sequential order without issue. As the scope expanded, I now need to do filtering based on criteria in two other lists of the same length that were created at the sam...

  CitizenNo3

  Discussions |

  Jun 28, 2023 1:21 PM

  2009 views | 3 replies

• Join data into existing table

  I'd like to join two data tables by a matching column. However, I do not want JMP to create a new table with the result. The joined columns from the second table should be appended at the first table. I thought the "Update main table ..." option would do this, however it does not work for me (tested JMP 14 and 15). How can I make this work? Here's a minimal example demonstrating the issue: I have ...

  JWi

  Discussions |

  Jun 28, 2023 1:14 PM

  4150 views | 4 replies

• Using Update() to add new rows into main table

  I am trying to update a table that sometimes contains new rows (based on an index). It seems that I need to use join, as the following does not seem to work (here, the index is name column). Names Default To Here( 1 ); dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt2 = New Table( "Little Class", Add Rows( 3 ), New Column( "name", Character, Nominal, Set Values( {"ALICE", "NEW_NAME", "OTHER_...

  FN

  Discussions |

  Jun 28, 2023 1:08 PM

  4389 views | 8 replies

• How can I apply stacked data in Hierarchical Clustering?

  Hi, I have a dataset in which one of the columns has some numeric values based on measurement at different known temperatures. The temperature at which the measurement is done is in another column. How can I cluster my experiments including these numeric values? My numeric values are not directly comparable since higher temperatures in nature yield higher measured values. Is it an example of stack...

  RepeatedPony834

  Discussions |

  Jun 28, 2023 8:45 AM

  1489 views | 2 replies

• Adding custom text and values to plots on different pages using a for loop

  Hi, I've attached a data table which aims to add a custom caption to each page of an X/Y plot graph builder report generated from the script saved within.Page is being controlled by the :Group variable, I need a way to add custom text along with a custom summary statistic (%CV in this case) to the plot for each :Group.For the most part the script is working (i.e. the text and the statistic are dis...

  EDM

  Discussions |

  Jun 28, 2023 8:13 AM

  1555 views | 2 replies