JMP User Community

Latest Discussions

Creating Groups after Database Query

Hi, I have a database query that returns a large table, 200+ columns, and would like to clean it up before working with.The columns have initial terms that signify the metrology tool source such as Raman, XRD, XRF, BET, PSA,...For each of these terms I would like to create a group and use the name from the above list to act as the name of the group.for example there are 20 columns that start with...
Hegedus1

Discussions |
Oct 18, 2024 11:16 AM

1197 views | 3 replies
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

1077 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

3452 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

1105 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

1122 views | 2 replies

Previous
Next

Latest Discussions

Creating Groups after Database Query

Hi, I have a database query that returns a large table, 200+ columns, and would like to clean it up before working with.The columns have initial terms that signify the metrology tool source such as Raman, XRD, XRF, BET, PSA,...For each of these terms I would like to create a group and use the name from the above list to act as the name of the group.for example there are 20 columns that start with...
Hegedus1

Discussions |
Oct 18, 2024 11:16 AM

1197 views | 3 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

3452 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

1256 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

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

720 views | 0 replies