JMP User Community

Latest Discussions

How do I update a column based on values from another column?

Hello, I'm a JMP 18 user.I want to see if a column contains a specific value and update a different column at the same row where the value was found. The below script does not work. Please assist.dt = Data Table("Logbook"); StatusList = :Status << Get Values; For( i = 1, i <= N Items(StatusList), i++, If( Contains( StatusList, "Not" ), :Name( "Status Error" )[i] = "Error", , //else ); );
Raquel

Discussions |
Oct 28, 2024 1:53 PM

888 views | 1 replies
JSL: change drawing order

Is there a JSL command to change the order of segs?
hogi

Discussions |
Oct 28, 2024 10:41 AM

1090 views | 2 replies
How do I do this with Regex substitution?

Only the content between [] is reserved, and even [] is not reserved.path="C:/Users/Administrator/AppData/Local/Apps/4.6.1.10576/Resources/Font/SystemFont/zh-hans.ttf"><color=(1.000000, 1.000000, 1.000000, 1.000000)><size=5.000000>[ABCDD]</size></color></font>I tried to write it this way, but there's still [Thanks!txt = Regex( txt, "(.[^[]{0,})\[(.[^]]{0,})]\(.{0,})", "\2", globalreplace ); getABC...
lala

Discussions |
Oct 27, 2024 6:51 AM

884 views | 1 replies
Security Warning When Running Addin on Server

I have several addins that run on my server with no problem. Just put a new one on the server and now I'm getting this error message: If I uncheck "Always ask..." and click Run it works. But the security warning comes up each time.
pmroz

Discussions |
Oct 26, 2024 4:42 PM

800 views | 1 replies
Color cells by conditional formatting

I need a script that looks through all columns and color cells with the value "< LOD". My script does not give the desired outcome. Any advice?dt = Current Data Table(); // Get all of the column names in the data table ColNames = dt << get column names( string ); NRows = N Rows( dt ); // Loop through each column and row to find "< LOD" and color the previous cell For( i = 1, i <= N Items( ColNam...
Steffen_Bugge

Discussions |
Oct 26, 2024 11:34 AM

1466 views | 2 replies

Previous
Next

Latest Discussions

Security Warning When Running Addin on Server

I have several addins that run on my server with no problem. Just put a new one on the server and now I'm getting this error message: If I uncheck "Always ask..." and click Run it works. But the security warning comes up each time.
pmroz

Discussions |
Oct 26, 2024 4:42 PM

800 views | 1 replies
delete CHAR cols if there's only a single value, no string variation

Wondering how I can script something to look at all the columns to see if there's at least 2 different values and delete all the single-value cols? I have thousands of 'feature' cols, all character-type, but a noticeable amount of them only have a single record in them...aka the distribution level = 1. how to detect and delete 1-record cols?
TriangularLlama

Discussions |
Oct 26, 2024 10:14 AM

1276 views | 3 replies
Optimizing Desirability With Uncontrolled Factor

I am looking for advice on how to automate maximizing the desirability of a process profile when I am locking one of the factors and having the others optimize around it. My process has an uncontrolled factor, so I need to adapt to what it's doing per unit I measure. My desired response can generally be achieved by adjusting the controlled factors, but the desirability situation is unique per valu...
V1N0V3R1T4S

Discussions |
Oct 25, 2024 2:44 PM

1765 views | 5 replies
Unable to run addins within Project

We have organized many scripts into an addin for our company. The addin responds but scripts will not run when invoked within 'Project'. Is this something that can be remedied through the addin scripting or does the script itself have to be contained separately within the project?
LynnWarren

Discussions |
Oct 24, 2024 10:20 PM

3518 views | 8 replies
JMP Slow Down after On Close with selection window

Hello, I'm trying to prompt users to make a selection of groups from a window that opens at the start of a script that defines an object to be used for the remainder of the script. When the user selects and uses the button box, it works great, but if they close with the window, JMP slows down and it becomes impossible to edit the script window without right clicking>Stop Script. Does anyone have ...
RahBarroso

Discussions |
Oct 23, 2024 7:57 AM

1226 views | 4 replies

Previous
Next

Latest Discussions

Graph Builder: Ordering my overlay by descending order according to the total value of each overlay category

Hello community, I come to you with a difficult question. Please see the image below for reference. I am using JMP 18, and I am trying to create a bar chart to show PPB values by quarter for various categories. The trouble I run into is that I want the category that has the highest total value from the chart to be on the bottom of the stack. For example, in the image below the category memory shou...
AttributedMouse

Discussions |
Oct 22, 2024 1:37 PM

709 views | 0 replies
Could JMP show in a single graph a sensitivity analysis and the probability of occurrence of a result?

Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Marco2024

Discussions |
Oct 2, 2024 5:15 PM

705 views | 0 replies
App Interface saved in a journal

Hi There
Some time ago, I created a nice interface using Application Builder and I saved it as a journal. Now I need to make a few modifications to the interface, rearrange buttons, add boxes, and so on. I am unable to import the journal into the app and have the interface appear in the Module tab. It is a very busy interface ...Is there a way to have it?
Thanks
Mioffe

Discussions |
Aug 7, 2024 5:01 PM

656 views | 0 replies
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

1098 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

784 views | 0 replies