JMP User Community

Latest Discussions

Close Invisible Tabulate Window

I am using Tabulate to summarize some data in a script and then saving the result to a table. I use the "invisible" property (command or whatever it is) so I don't see the intermediate Tabulate window. However, I end up with a bunch of invisible Tabulate windows that accumulate as I run through the script. See image below... I tried dtab << Close but it doesn't work. Can someone tell me how to c...
scott1588

Discussions |
Jul 26, 2024 7:46 AM

1513 views | 2 replies
Interactive / Dynamic Filtering or Choice Menu

I have a table named dt. I take the unique values of some columns and I create the following menu that gives the ability to the end user to filter the dt table based on the values of the columns and take a subset of this.
However, taking the unique values of its column is risky because you may end up choosing a combination of attributes that doesn't exist in the table.

Is there any way to make this...
Georgios_Tsim

Discussions |
Jul 26, 2024 2:12 AM

1669 views | 4 replies
How to select the right data table to create a dashboard in a JMP Project

I have a long script where in the first part different data tables are joined together and some calculations are made. The result of this part are 3 data tables and several graphs in one of the data tables. The second part of the script would create a dashboard from the already made graphs/plots. If I run the script it makes an empty dashboard, but if I run the first part then select the data tabl...
IloinenHamsteri

Discussions |
Jul 26, 2024 2:07 AM

860 views | 1 replies
How to make JMP home window invisible ?

Hi all,

I's using JMP 18 and I have a Python script that runs several tests, queries data from SQL, and saves the results with different names. I then execute JSL scripts for plotting the data. However, each time a JSL script runs, it opens the JMP Home window. If I run 10 tests simultaneously, it opens 10 JMP Home windows, which blocks my screen view. Although I'm making the data tables invisible...
mati

Discussions |
Jul 25, 2024 6:32 PM

2275 views | 5 replies
JMP 18 creating exe from python code using pyinstaller

All, I havent seen this question asked, but if I make an application using JMP 18 embedded python, can I leverage Pyinstaller to make an executable so other user can also use the application without needing JMP18 or installing all the python packages?
Zach_Eyde

Discussions |
Jul 25, 2024 12:48 PM

2472 views | 5 replies

Previous
Next

Latest Discussions

How to select the right data table to create a dashboard in a JMP Project

I have a long script where in the first part different data tables are joined together and some calculations are made. The result of this part are 3 data tables and several graphs in one of the data tables. The second part of the script would create a dashboard from the already made graphs/plots. If I run the script it makes an empty dashboard, but if I run the first part then select the data tabl...
IloinenHamsteri

Discussions |
Jul 26, 2024 2:07 AM

860 views | 1 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

1290 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

1591 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

1343 views | 2 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

787 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