JMP User Community

Latest Discussions

How to avoid error when using the row change handler?

go_down_expr = Expr( cur_row = (dt << get selected rows()); If( N Items( cur_row ) == 0, New Window( "Alert", <<size( 300, 100 ), Border Box( top( 10 ), bottom( 10 ), Left( 10 ), Right( 10 ), Text Box( "No selection" ) ) ), N Items( Loc( crows > cur_row[1] ) ) == 0, dt << gotorow( crows[1] ), dt << go to row( crows[(Loc( crows > cur_row[1] ))[1]] ) ); ); f = Function( {a = [1]},...
lehaofeng

Discussions |
Jun 11, 2024 6:06 PM

1233 views | 2 replies
How to Process Continuous Alarm Data Using a JMP Script

I want to count the number of times an alarm occurs in the process. The data comes in every second. When an alarm occurs, the data shows 1, and if the worker doesn’t turn off the alarm, the number 1 continues to appear.

The problem is, if the alarm is not turned off within 10 seconds, it actually counts as one alarm but appears as 10 alarms in the data.

I want to leave only one row and delete the re...
Ronaldo

Discussions |
Jun 11, 2024 3:25 PM

1354 views | 2 replies
How to properly create a button column and use variables in the button's script

JMP community expert, I'm from China.
The following problem description comes from machine translation. Please don't mind that the grammar can be a little strange. I want to create a button column to write some scripts.
I mainly use the following methods to create button columns:cb = Expr(Col Box("Title")); for each( {v, i}, list, Insert Into( cb, button box("name", Script...) ) );I inevitably u...
fengzhuansha

Discussions |
Jun 10, 2024 10:36 PM

1332 views | 2 replies
Consolidating Repeated Values

I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....
S_Boilermaker

Discussions |
Jun 10, 2024 1:46 PM

970 views | 1 replies
Create a new concatenated table based on two existing tables

Hi, I have input table A that looks like this, Input Table B looks like this, I want to create an output table C: that should look like this, I can do this manually. Is there a way to script this?
AsymptoticCos

Discussions |
Jun 10, 2024 1:29 PM

1023 views | 1 replies

Previous
Next

Latest Discussions

Consolidating Repeated Values

I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....
S_Boilermaker

Discussions |
Jun 10, 2024 1:46 PM

970 views | 1 replies
Show labels for selected rows only

In Graph Builder, I want to show a data label (not a hover label) for selected rows only. As a demo, I tried the following code: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Try( Show( dt:Selected Name ), dt << New Column( "Selected Name", Character, Set Formula( If( Selected( Row State( Row() ) ) == 1, :name ) ) ) ); dt:Name << Label( 0 ); dt << Clear Row States <...
matth1

Discussions |
Jun 10, 2024 1:36 AM

2015 views | 4 replies
How to import binary Pi Tags from web server into JMP

We are trying to import binary PI tags from our PI web server into JMP which does not work however.The PI tag is character and has the names "Open" and "Closed" and values 1 and 0 respectively. We verified that this binary PI tag is being populated in the web server: When using the integrated "Import from PI Server" or our own application which is similar, the columns of the data table are not pop...
Theresa3003

Discussions |
Jun 6, 2024 6:49 AM

1219 views | 2 replies
Graph builder window size in Journal: Scaling issue [JSL]

Hello, I'm trying to write a script and run it using journal. The script is supposed to plot different graph builder windows. The issue I'm having is that sometimes when I try to change the axis setting (Min, Max, and Increment), the window gets very small and the axis setting becomes different than the one in the script. Ex: The interesting thing here is that when I try to use the re-run in a ...
RA899

Discussions |
Jun 6, 2024 5:44 AM

1233 views | 1 replies
release notes

When will the release notes for JMP 18 and JMP 18.0.1 be available from JMP - New Features and Release Notes ?
hogi

Discussions |
Jun 5, 2024 2:13 PM

2281 views | 3 replies

Previous
Next

Latest Discussions

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

785 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
DataTable Prompt in application builder on module load

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
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

662 views | 0 replies