Welcome to the JMP User Community!

Latest Discussions

• Conditional formatting by row state of different columns.

  Good Day,   I have 1.7mil rows of data that are linked with common identifiers. I can format smaller portions of it it in Excel but with the size of the file (greater than the excel limit) and...

  Frogger

  Discussions |

  Jun 28, 2023 1:41 PM

  1140 views | 3 replies

• 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 ma...

  CitizenNo3

  Discussions |

  Jun 28, 2023 1:21 PM

  773 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...

  JWi

  Discussions |

  Jun 28, 2023 1:14 PM

  2328 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)....

  FN

  Discussions |

  Jun 28, 2023 1:08 PM

  2138 views | 8 replies

• Top 10 Values in Many Columns

  I have a data table with a few thousand columns. I am looking to find the top "X" number of values in those columns, by another variable. For instance, I want to know the columns with the 10 highest ...

  dkraeuter_sunne

  Discussions |

  Jun 28, 2023 12:31 PM

  499 views | 3 replies