Welcome to the JMP User Community!

Latest Discussions

• How to insert or update datatable into database using script

  Hi, everyone.
  I'm using JMP 17. I want to insert or update the data in datatable into external database ssms.
  
  Currently, I have a datatable. I want to compare the row of datatable. If the row of datatable is not exist in database then insert into database, else if it is existed in database then update into database.
  
  I know the SQL have insert or update function but don't know the JMP script can make ...

  Celine1

  Discussions |

  Dec 14, 2023 5:30 AM

  1456 views | 1 replies

• How to get check boxes to be change (or become visible or active) based on a previous selection in a modal window?

  In the following script, I would like to do the following:Based on the selection of TestTech, I want the appropriate TestStage check box list to appear (appear is preferred, if not become active if all options need to be visible). So,if Tech1 is selected, all TestSages with _Tech1 should be available to the user for selectionif Tech2 is selected, all TestSages with _Tech2 should be available to th...

  Neo

  Discussions |

  Dec 13, 2023 1:09 PM

  9138 views | 24 replies

• How to set control limit in IMR chart and Xbar R chart

  Greetings,
  I'm using JMP 17, I tried to set control limit for IMR chart and X bar R chart. 
  Although I have set the control limits, when I run the script, the control limits do not change as I have set them.
  dt is the data table.
  below is the script for IMR chart:dt = Open( "$SAMPLE_DATA/Time Series/Workers.jmp" ); Gra = dt << Control Chart Builder( K Sigma( 2.5 ), Variables( Subgroup( :DATE ), Y( ...

  Celine1

  Discussions |

  Dec 13, 2023 9:03 AM

  1993 views | 1 replies

• Use for loop variable in a formula

  Trying with this script but variable "l" is not working, only variable "k" is working. Anyway to solve this? For( k = 40, k <= 54, k += 2, x1 = 1; x2 = 8; y1 = 40; y2 = 54; m = (y2 - y1) / (x2 - x1); c = y2 - (m * x1); l = (k - c) / m; dt << New Column( "Test" || Char( k ), Numeric, "Continuous", Format( "Best", 12 ), Formula( If( :Strobe == 1, If( :Tested Variable == 0...

  Sysy13

  Discussions |

  Dec 13, 2023 5:59 AM

  8332 views | 7 replies

• Extract Part of the String

  Hello, I have a string and I want to extract everything but the last four characters of the string.  So, the following string, 12/9/2023 19:05:57:754 would results in, 12/9/2023 19:05:57 How do I do this in JMP

  JMP_9006

  Discussions |

  Dec 12, 2023 11:23 PM

  2035 views | 3 replies