JMP User Community

Latest Discussions

How to use a simplest script for subset ?

set table aircraft incidents as a sample data to explain what function I want to get.subset all row, when the charators in column starts "Accident Number". there is way--> select data filter-->filling "LA"-->manual select all list out items, then copy the scripts as followingthis script is really very long, another disadvantage is when there are some new accident number start with "CH" but not inc...
Sean_ShCn0

Discussions |
Jul 25, 2024 12:34 PM

2394 views | 5 replies
Import Unpopulated Excel Data

I am writing a script that will import an excel sheet and perform various cleaning and analysis actions on it. However, the excel sheets that will be imported are updated daily and have 20,000+ rows that will only populate when you refresh it in excel. I have not been able to find a way to refresh this data sheet in the excel import wizard or in JMP without going into the excel sheet and refreshin...
S_Boilermaker

Discussions |
Jul 25, 2024 9:53 AM

1287 views | 2 replies
Cycle Problem

I have this recurring cycle detected problem that I cannot figure out and I'm hoping someone can help me. See the attached example script. It generates a table. The idea here is I want to label each continuous runs of 1 in Column 1 as an Event with a sequential number. The formula works. But when I make any modifications to the table or Rerun Formulas I get one, two, or sometimes three cycle detec...
scott1588

Discussions |
Jul 25, 2024 8:53 AM

4983 views | 11 replies
Have an ANOM report grouped by a column hence has multiple summary reports. How do I extract each summary report into a data table ?

kd_kel

Discussions |
Jul 24, 2024 10:03 PM

1590 views | 3 replies
Save script to data table (All objects )

How do I use the save script to data table (all object) syntax to save a data table sorted : by a column
kd_kel

Discussions |
Jul 24, 2024 9:57 PM

1774 views | 4 replies

Previous
Next

Latest Discussions

Import Unpopulated Excel Data

I am writing a script that will import an excel sheet and perform various cleaning and analysis actions on it. However, the excel sheets that will be imported are updated daily and have 20,000+ rows that will only populate when you refresh it in excel. I have not been able to find a way to refresh this data sheet in the excel import wizard or in JMP without going into the excel sheet and refreshin...
S_Boilermaker

Discussions |
Jul 25, 2024 9:53 AM

1287 views | 2 replies
Have an ANOM report grouped by a column hence has multiple summary reports. How do I extract each summary report into a data table ?

kd_kel

Discussions |
Jul 24, 2024 10:03 PM

1590 views | 3 replies
JMP 17 script graph size for report

Is there a way to set the frame size for graphs in jmp 17 script so that when the report is generated with multiple graphs the graphs are of a particular size. Ideally want to be able to customize each individual graph size The script below used to work and set the size correctly in jmp 14 but it does not do the job in jmp 17 graphname = datatable << Overlay Plot( X(:x), Y(:y1, :y2, :y3), Ove...
UpliftTiger788

Discussions |
Jul 23, 2024 11:29 PM

911 views | 2 replies
Summary datable with comma separated values in Column

I would like to make a summary of table in SHEET1 and include Wafers in it. My desired output column is in SHEET2. I wanted to develop a script which can give me output like SHEET2. Note SHEET2 is summary of SHEET1. In Sheet2, I wanted wafers to be separated by comma. The wafers should be num(right(Wafers,2)) in the SHEET2.
pankajsync

Discussions |
Jul 23, 2024 10:19 AM

1341 views | 2 replies
How to pull data regularly from another addin?

need make a addin that can query data from another addin(premade with ui to extract data and don’t have access to script) that is connected to a database.

Is there a workaround?

Pls help
DecileIbex201

Discussions |
Jul 22, 2024 11:31 PM

1481 views | 3 replies

Previous
Next

Latest Discussions

Tracking down a cycle error

When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula. Here is the formula: and here is the log entry showing the issue Can anyone help me understand what is going on here? The data table actually works fine after I click ...
scott1588

Discussions |
Jun 24, 2024 11:47 AM

1099 views | 0 replies
How do I make scattorplot Matrix with multiple cloumns I select?

Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
NagneTE1

Discussions |
May 27, 2024 5:18 PM

786 views | 0 replies
graph builder bug - x group shift

(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...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

720 views | 0 replies
Project ignoring H Splitter Box Set Sizes . . . sometimes

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...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

710 views | 0 replies
Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

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...
sm3001

Discussions |
Mar 21, 2024 12:49 AM

932 views | 0 replies