Welcome to the JMP User Community!

Latest Discussions

• Align matching values in two different columns

  Hi all ! I had a basic question of how can align the same numeric value in two different columns.For example:  00112340123456012345687654320987654087654320886677309876543456654123456468758633456654123456488667739860321687586323503419860321 I want the values to match each other and if they do not match they should be still in the table  Like in the above examples there is no matching value 0011234....

  Apurva14

  Discussions |

  Jul 1, 2019 3:24 PM

  2511 views | 1 replies

• Checking loop through a table to check if the column is numeric or nominal

  I have the following table that is the result from stacking and splitting a much larger table. As you can see, X1, 3 and 5 are Numeric and X2, 4 and 6 are Characters. Because this is a results of stacking and splitting, everything is converted to Nominal and Character, is there away to loop through all the columns, check if the value in the 1st row is numeric/continuous and convert the X1, X3 and ...

  nguyendv0610

  Discussions |

  Jul 1, 2019 3:19 PM

  2765 views | 1 replies

• Load Factors table into DOE using JSL

  I am designing multiple DOE using risks assesments done in Excel. I wrote a script to organize all the variables into a neat table and converted the properties to that of a factors table (credit to a previous post (Saving a data table as a factors tabledt3 = Current Data Table(); nomdata = dt3 << get column names( nominal ); condata = dt3 << get column names( continuous ); For( i = 1, i <= N Ite...

  nguyendv0610

  Discussions |

  Jul 1, 2019 2:12 PM

  2892 views | 1 replies

• Accelerated Reagent Stability Studies

  Hi All,I'm exploring JMP Platform options for analyzing accelerate reagent stability studies.  A typicall study would consist of the following. Store reagents at 4 or 5 different temperatures (e.g. 15 degC, 20 degC, 30 degC, 35 degC, 40 degC). The "activity" of of reagent (Concentration of a molecule, activity of an enzyme, etc.) would then be measured at 4-5 time points (e.g. 1 day, 4 days, 7 day...

  DennisB

  Discussions |

  Jul 1, 2019 9:48 AM

  4315 views | 3 replies

• Exporting Select Columns to CSV Filtered by Formula Column

  Hey everyone,  I'm new to JMP scripts and I'm hoping this may help others too.  From the sample data screenshot below (stored as a .JMP file), I'd like to select Material and Month and round Stock to a whole number.  I'd then like to filter only records where the rounded Stock calculation is greater than zero.  Finally I'd like the results to be saved as a CSV file.    Here is my initial attempt a...

  William_S

  Discussions |

  Jul 1, 2019 9:34 AM

  3786 views | 2 replies