find all rows with value>50 and subsequent 10 rows
I need to write a script to find all rows in the table with value > 50 and return 10 rows right after those rows. Could someone help me with this script please? Thank you!
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI need to write a script to find all rows in the table with value > 50 and return 10 rows right after those rows. Could someone help me with this script please? Thank you!
Hi,
I wrote a script that 1) queries a table(myDT) to build a control chart on and 2) another table(specLimitsTable) and 3) a loop that takes data from the second table to set spec limits on table 1. It works just fine in JMP PRO and steps 1) and 2) work fine in JMP LIVE but when I add the 3rd part it says failed to regenerate when I go to refresh my data. The JSL that works in JMP PRO is below:...
How do I delete Smoothing spline controls? I have a report with bunch of splines and this list of controls takes the whole page effectively collapsing the chart. I saw a similar question, but I have another part in my script and the solution doesn't work.How do I remove it? Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
g=vlistbox(Big Class<<
Fit Group(
Bivariate(
Y(:heig...
We are looking for an enterprise solution for JMP software being used currently. It should be web based where nothing is installed in personal computers/ laptops. Scientists can log on to web-based solution and pull data from Data Lake, do their analysis and create visualizations in form of bar graph/ charts on pre-clinical data just like they do in JMP today. Multiple people can use this solution...
Hello, I'm looking for a JMP built-in function that I'm pretty sure it exists but I could not find.It helped you create a new column in a datable that will affect to each row the order of appearance of a set of columns. For example, in this table, I want to count the order of appeareace of each set of values {col1, col2} : It should give me a third column like this : Maybe I'm wrong, but if any of...
Hi,
I wrote a script that 1) queries a table(myDT) to build a control chart on and 2) another table(specLimitsTable) and 3) a loop that takes data from the second table to set spec limits on table 1. It works just fine in JMP PRO and steps 1) and 2) work fine in JMP LIVE but when I add the 3rd part it says failed to regenerate when I go to refresh my data. The JSL that works in JMP PRO is below:...
We are looking for an enterprise solution for JMP software being used currently. It should be web based where nothing is installed in personal computers/ laptops. Scientists can log on to web-based solution and pull data from Data Lake, do their analysis and create visualizations in form of bar graph/ charts on pre-clinical data just like they do in JMP today. Multiple people can use this solution...
Hello, I am trying to save the content from a window into the Text file. After saving it, I am trying to give user the capability to read the content from the saved text file and populate it in the Text Edit Box so that they don't have to retype again. I was able to save the text file by using Save Text function.I was also able to browse the text file by using Pick File function. I need help with ...
Following is an example similar to my actual data case. I am interested in looking at the correlation between two process variables known to be dependent on each other. Especially, I would like to understand the wafer number dependence of the correlation.For my actual data case, unlike the example case here, the x-axis variable is bi-modal on the wafer number (first say n wafers sit on one mode, ...
I’m working on a script to iterate through a list of columns and I’ve hit a snag. I need to be able to output the column reference in the form ":Technology Default” but every method I’ve looked at outputs "Column("Technology Default")" . I looked this up online and it appears that the reference I need is a "column reference" when what I get is a "column object reference". Is there a straightfor...
(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer(
Text Columns( :col1)
);
obj << Stemming("Stem for Combining");
obj << Add Recodes(
{{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...