Welcome to the JMP User Community!

Latest Discussions

• MongoDB: What is the best connector, is ODBC connector sufficient, or do I need BI Connector?

  Dear all,from another contribution by @JumpingAC I got the hint that there is a Connector for MongoDB:https://docs.mongodb.com/bi-connector/master/it leads to a file "mongodb-connector-odbc-1.2.0-win-64-bit" for my systemand then I got the hint, that there should be a MongoDB Connector for BIhttps://www.mongodb.com/download-center/bi-connectorbut:"The MongoDB Connector for BI is available as part ...

  Georg

  Discussions |

  Sep 25, 2024 5:12 AM

  7223 views | 4 replies

• Fit Spline for multiple columns and saving predicted values

  Hi all,    I have a lot of different columns from an FTIR spectra experiment, and in order to correct the baseline, I need to perform a Fit Spline on each column (one column = one spectra). I would like to do this automatically using JSL, so I don't have to save hundreds of "Predicted values" by hand.  I tried to create a code but somehow it doesn't want to save the values or put 0 in each columns...

  LGaspard_98

  Discussions |

  Sep 25, 2024 5:10 AM

  2208 views | 2 replies

• Find - or not find?

  According to Jmp manual the standard option By Column in the Search/Find window works like this  And indeed, if there are several cells with the same value, Jmp uses this rule to step through the matching cells and at the end it starts a new round from the top left:(view in My Videos) But:(view in My Videos) So, if you want to be sure to find a matching cell, please take care that you select the r...

  hogi

  Discussions |

  Sep 24, 2024 10:31 PM

  2394 views | 2 replies

• solving an integral for pharmacokinetics work

  Hi, Pharmacokinetics: mathematically characterizing how a drug  enters and leaves the body In pharmacokinetics experiments the influence of the stomach is ignored in most data analyses, which is not appropriate. Stomach emptying can be described with the equation (in which t=time):Plateau×(1-e^(-Ks × t))^ß  (Ks=rate, beta =lag phase)Subsequently, the absorption kinetics of a test component can be ...

  tvkmez11

  Discussions |

  Sep 24, 2024 12:11 PM

  7424 views | 5 replies

• How to write a formula that counts number of rows that are not excluded?

  I am trying to write a simple formula that will count the number of rows in my datatable that are not excluded. I want the total to be updated as I change row states using the graph builder. In another part of the formula I was able to successfully use the Excluded () function, e.g.  <jsl> X = Col Sum( :MG1_2520_LH_Setting, Excluded() ); However, I am using N Rows() to count the total number of ro...

  BrianB

  Discussions |

  Sep 24, 2024 7:58 AM

  3094 views | 4 replies