JMP User Community

Latest Discussions

Column Header Ordering

After transposing data table, Data Table( "Overall" ) << Transpose( columns( :Value), By( :Department, :Resource, :Chart ), Label( :Date), Output Table( "report overall" ) );My headers which is presented by date is no longer in order. Which I then have to mannually drag and drop to have it fixed. Luckily it only involves 7-8 columns. Nontheless, doing so eats up my time which I do not initial...
Azim

Discussions |
Oct 18, 2024 4:53 AM

1076 views | 2 replies
Can implement this substitution with an operation with a regex?

For example, this file is a txt file.TAB spacing:
Column 2 contains, column 2 contains
The maximum number of rows is 5
Can you use regular substitution to replace rows with less than 5 such symbols to complete the cell with a total of 5 similar symbols?
Make up as shown in the figure.Thanks Experts!
lala

Discussions |
Oct 18, 2024 2:29 AM

3451 views | 13 replies
Multiple column color formatting

I have multiple columns both numerical and characters. I want to color format for all numeric columns. My first attempt was using if function Local ({dt},
dt = Data Table ("Cpk report overall");
dt << Begin Data Update;
For Each Row(
If(
:"Row 1"n >= 1.33, :"Row 1"n << Color cells ("Green", Row()),
(:"Row 1"n < 1.33) & (:"Row 1"n >= 1.06), :"Row 1"n << Color cells ("Yellow", Row()),
:"Row 1"n < 1.06, :"...
Azim

Discussions |
Oct 18, 2024 2:06 AM

1103 views | 2 replies
Plot multiple Y axis from a list of column on JSL

Hi all, I have an issue with plotting some data from an FTIR experiment. I have a list containing the name of the columns I want to plot on the Y axis so that they are all overlaid on the same scale (not on top of each other). But somehow I can't figure out how to write the code.
I tried like this but it seems like the "Position([1])"isn't really working. Can anyone help? Thanks!

gb = dt<<...
LGaspard_98

Discussions |
Oct 17, 2024 11:55 PM

1118 views | 2 replies
No output result for summation of multiple columns

Trying to create a new column to represent a grouping of several columns together by using the sum function in the formula box. I've tried a few different ways (manually clicking each column to be used and using the + sign, selecting the statistical sum function and adding each column, and highlighting all needed columns then right clicking to Combine Sum) and each time the formula allows me to co...
TAKAMX

Discussions |
Oct 17, 2024 11:11 AM

1851 views | 5 replies

Previous
Next

Latest Discussions

Can implement this substitution with an operation with a regex?

For example, this file is a txt file.TAB spacing:
Column 2 contains, column 2 contains
The maximum number of rows is 5
Can you use regular substitution to replace rows with less than 5 such symbols to complete the cell with a total of 5 similar symbols?
Make up as shown in the figure.Thanks Experts!
lala

Discussions |
Oct 18, 2024 2:29 AM

3451 views | 13 replies
using web browser box, is there any way I can have it retain BROWSER level zoom between "navigate" events?

I'm firing events into the browser box, but every time I navigate a URL my browser level zoom gets reset.Browser level zoom like in chrome is controlled with "{ctrl} + {mouse wheel}" or "{Ctr}l + {+}" Is there any parameter I can set to control this or maintain the users previous setting?Coming in at 100% every time isn't ideal.I have full control of the web page too, but I don't want to do a CSS...
xxvvcczz

Discussions |
Oct 16, 2024 8:02 AM

1452 views | 1 replies
How to use a variable in JSL to set the levels of a DOE factor?

I'm trying to add a factor to a DOE using a variable instead of hard coding the levels. The end goal is to provide the user with a simple interface set the levels for one of the factors. The following code doesn't work and the factor just ends up with L1 and L2 as levels. Names Default To Here( 1 ); levels = List(1,2,3); d = DOE( Custom Design, Add factor(Discrete Numeric, levels) ); d << Make...
ChrisMuenzer

Discussions |
Oct 15, 2024 7:30 PM

1255 views | 2 replies
Script to select to generate an options menu to select columns and rows based on multiple parameters.

I have been trying to teach myself JSL and after going back through the Introduction to the JMP Scripting Language again, I rediscovered the "Make Specific Report" script which allows for the selection of a specific date range (row selection) and Die temperatures (column selection) from the "Process data" data table. I have been trying to make a similar script and apply it to some stability data a...
QCSci_CK

Discussions |
Oct 15, 2024 8:13 AM

709 views | 1 replies
Collision in SQL Select-statement between special escape characters (bracket and backslash) and bracket in column name with quotation marks around it

I'm running into a problem with an SQL Select-statement using column names that are including brackets, because the end brackets of the column names end up next to backslashes (due to using quotation marks within quotation marks: " \!" column name [ units ] \!" " ) and this interferes with the surrounding special escape characters (bracket and backslash: \[ ]\ ). The SQL-statement is written betwe...
Dape

Discussions |
Oct 15, 2024 7:44 AM

2690 views | 8 replies

Previous
Next

Latest Discussions

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

718 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

Column Header Ordering

Can implement this substitution with an operation with a regex?

Multiple column color formatting

Plot multiple Y axis from a list of column on JSL

No output result for summation of multiple columns

Latest Discussions

Can implement this substitution with an operation with a regex?

using web browser box, is there any way I can have it retain BROWSER level zoom between "navigate" events?

How to use a variable in JSL to set the levels of a DOE factor?

Script to select to generate an options menu to select columns and rows based on multiple parameters.

Collision in SQL Select-statement between special escape characters (bracket and backslash) and bracket in column name with quotation marks around it

Latest Discussions

Could JMP show in a single graph a sensitivity analysis and the probability of occurrence of a result?

App Interface saved in a journal

Tracking down a cycle error

How do I make scattorplot Matrix with multiple cloumns I select?

graph builder bug - x group shift

JMP Events

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration