Welcome to the JMP User Community!

Latest Discussions

• Sequentially exclude rows?

  Hi.  Is there a command to exclude rows that doesn't also unexclude previously excluded rows?  In my script, I'd like to exclude rows in a table that already may have some of these rows excluded.  The problem is that if I use Exclude, it may actually Unexclude previously excluded rows.  For example:Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); dt << Clear Row States; r = dt <<...

  nikles

  Discussions |

  Mar 8, 2021 12:35 AM

  1306 views | 2 replies

• Tweak a model before running fit model, list box not respecting special column names

  I’m looking to build a copy of this model effects dialog from fit model: Goal is to build a script that will read in this effects expression from the model script that DOE saves in the table, allow people to tweak the effect expression and then run some analysis using fit model with the new effects expression.If you run the dialog in below script, you will see that it reads in the effects expressi...

  pauldeen

  Discussions |

  Mar 7, 2021 10:59 PM

  3100 views | 6 replies

• Using loop variable as column input

  Hello,   I am wondering if it possible to use my for loop variable, i, as an input for a new column, depending on the value of another column.  Here is what I am thinking, but cannot get to work. dt << New Column("Site", Numeric, Formula(    For(i = 1, i <= 8, i++,       If(Contains(:Column1, i), i);    ) ));  

  wyatt_dunn

  Discussions |

  Mar 5, 2021 1:10 AM

  1462 views | 2 replies

• How to color code by sample type in a PCA?

  I am novice at JMP, and I am making my first PCA that I would like to color code by sample type (treatment) ... but I cannot figure out how. Any advice?My study compares a variety (15+) of carbon composition metrics of the leaves, litter, and soil of two different plant species in rivers versus creeks -- overall that is 12 sample types, or treatments.Any help would be greatly appreciated!I have JM...

  harvestnoon

  Discussions |

  Mar 4, 2021 10:14 PM

  3257 views | 1 replies

• weekly report with SQLquery tables

  I have 3 SQLQuery tables generated. Few questions:To generate a weekly report, what’s the best way to store them, so next week once I have updated data, I can replace the data source once, and then the 3 query tables run automatically? Is it like journal, project, or dashboard?How to combine the scripts of the 3 query tables in order to run them all at once with updated data? I saw in each table t...

  joann

  Discussions |

  Mar 4, 2021 1:27 PM

  2575 views | 2 replies