Welcome to the JMP User Community!

Latest Discussions

• JSL function with SQL Join pulling data rows 3 times compared to one without JOIN -why?

  The first function below with SQL INNER JOIN pulls each data rows (for LNo) two additional times from the database compared to the second function below without JOIN. Where am I going wrong? Names Default To Here( 1 ); opnDtb = Function( {R, M, T}, {dtm}, dtm = Open Database( "Driver=SQL Server; Server=ABCD-EFGH; DATABASE=myDB; Trusted_Connection=Yes;", "SELECT SM.[LNo], SM.[TestDate] A...

  Neo

  Discussions |

  Dec 7, 2023 9:59 AM

  1032 views | 1 replies

• how to understand the relationship between different predictors

  From a large car data set, a company would like to have a tool to predict prices for used cars. Therefore they first need to understand the relationship between different predictors (independent variables) and the used cars price.For the following questions we assume that the price is determined by a number of predictors contained in the dataset.Investigate which continuous predictors have an infl...

  BaggingSpaces55

  Discussions |

  Dec 7, 2023 9:20 AM

  1539 views | 3 replies

• Help with using a SQL stored procedure to pull data using JSL

  Good evening,   I'm a beginner to JSL.  I think suspect that I have a syntax error or something.     I'm trying to run an SQL stored procedure from a JSL script.  My database connections seem to work correctly (see when the query is a select statement).  However, I can't get the stored procedure to run and give me the data table.  Below I've listed: 1) the query formula that works (the select stat...

  PleaseRecycle

  Discussions |

  Dec 7, 2023 7:40 AM

  2274 views | 2 replies

• Design of Experiments with hard-to-change factor and blocking

  Dear JMP community, I am using the DoE JMP Custom Design Platform to build the following design:* 4 continuous factors (2 hard to change and 2 easy to change)* 1 blocking factor* 18 experiments should be conducted in two days (9 in the first day and 9 in the second)A possible effect between both days should be modelled with the blocking factor by constructing two blocks with 9 runs per block. Now,...

  mike2

  Discussions |

  Dec 7, 2023 5:57 AM

  3065 views | 3 replies

• New data added in excel - how to refresh in JMP

  My source data is in excel. I created a script to import the data with wizard into JMP and then further scripts do many things in JMP, ultimately creating graphs. And the scripts re-run just fine as long as I just look at the original data. But when I add new rows in the excel and run the scripts, the new data is not included there. I just see the same data that was in the excel when I created the...

  Markn

  Discussions |

  Dec 7, 2023 5:30 AM

  10211 views | 24 replies