Welcome to the JMP User Community!

Latest Discussions

• Setting up ODBC Query to run daily

  I am currently querying a couple of DB's using windows ODBC driver to read into JMP and eventually into a Data Table. I'd like to automate this process to update the DB and corresponding output scripts & Dashboards to run (for example) every day @ midnight. Does anyone have any literature or reccomendations on how to do this? Thanks all!

  hmiles

  Discussions |

  Jul 2, 2019 4:42 AM

  3411 views | 3 replies

• 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

  2528 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

  2792 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

  2920 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

  4386 views | 3 replies