Run saved scripts after a data table update
Hi, I saved a lot of scripts in a data table that I want to keep using after a major update of my data matrix, is this possible? How?Thanks for advice, Frank
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I saved a lot of scripts in a data table that I want to keep using after a major update of my data matrix, is this possible? How?Thanks for advice, Frank
Hi everyone, I figure what I want to do is really easy, I just haven't come up with a good way to do it. I have a large table with a substantial number of identical rows which I want to rename uniquely but in a reproducible way. Currently, I have a script that takes the following column: A number 1 B number 1 A number 2 A number 3 A number 3 A number 3 B number 3 B number 3 B number 3 ... In...
Got back to JSL after a long break and feeling rusty.Can't get a select where statement work.I'm sure it's pretty simple.I'm trying to select rows by comparing a value with values in two other columns. dt << select where( :Col1 > :Col2 & :Col1< :Col3);
Col1 is character(on purpose) because it needs to be used further and Col2,Col3 are numeric cols.What is wrong?I even tried doing this from GUI but ...
I am working on a data table with more than 4000 rows.To get the data in required format I'm using word and substr functions within for each row loop. The functions work as expected for first 160 rows and no action is taken on rows beyond this point.Is this a network issue ? I tried adding Wait but doesnt help. For Each Row(dt:col1 = Word(1,dt:col1, "S"));
For Each Row(dt:col2 = Substr( Char(dt:c
...
Hello, I have a collection of X,Y curves I would like to analyize with Functional Data Explorer. The problem I'm facing is that some of these curves are truncated at a certain value of X because for greater values a physical failure occurs during data collection. Some other curves reach the maximum possible X with no failure. FDE is appearently not managing very well the presence of curves wit...
Hi, Anyone has any idea how do we find the allowable limits that a few factors can operate in order to maintain a certain defect rates. This video from robert actually shows how to find the best settings in order to achieve lowest defect rate with the assumption of normal distribution in these factors. What I am looking for is how do i determine what is the maximum variation allowable in order to...
I have a fairly large JMP data table (132k rows, 2860 columns) which also has a large number of formula columns (200+). I regularly import new data into this file, so I want to keep all of the formula columns "live" so they will auto-populate when new data is added. I've started to run into issues with the speed of formula recalculation. At first the formulas were mostly simple arithmetic (addit...
How Can I konw if the aliasing exists in the Alias Matrixthe involving two-way interactions and main effects? For example, in this Alias Matrix, what does 1 and 0 mean?
I am trying to write a script whose values depend on the value of another column.I need to create a new column i.e second column below.Need to assign vales as followsSun = 1,Mon = 2 and so on.(4) => 2 , (6) => 4,5 => 1, 7 => 3Eg : Sun(5) is 11.How can I script this?Sat (4)72Sun (5)11Sun (4)12Mon (5)21Mon (4)22Tue (5)31Tue (4)32Wed (5)41Fri (7)63Wed (6)44Thu (7)53Thu (6)54Fri (6)64Sat (7)73
I am trying to write a code where I can get value from a row and then repeat it in 13 successive rows of the same column.I want to read value from row number 15 and repeat in rows 16 to 28.Then read value from row number 29 and repeat until row 43 so on and so forth.How can I do this in jsl? Thanks
Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...