JMP User Community

Latest Discussions

How to get only "Cp" value for a column in a Datatable?

Hi, I would like to get Cp value for a column in my data table to use it in multiple script location to tabulate it. With the available function "obj << Process Capability( LSL( 5 ), Target( 40 ), USL( 75 ) );" it is clear that we can get all process capability parameters in a plot. However i would like to get Cp value for a column and assign it to a variable in my script to use it in multiple sc...
AlexR846

Discussions |
Mar 12, 2022 12:00 AM

3674 views | 8 replies
Help needed with nested if and else statement

I'm using if else statement to bucket certain FS*/SS* as CAT1 and CAT2 .All remaining FS*/SS* that do not belong to CAT1/CAT2 need to be classified as CAT3.Having trouble with writing else part for CAT3.Any help appreciated. cdt = open("temp\data.csv"); cdt=current data table(); sum_lst2 = {}; sum_lst3 = {}; sum_lst4 = {}; col_lst2 = cdt << get column names( Numeric ); For( i = 1, i <= N Items( c...
ENTHU

Discussions |
Mar 11, 2022 5:35 PM

6235 views | 9 replies
How do I multiply all data values by a multiplier for each column that is identified in another table?

How do I multiply all data values by a multiplier for each column that is in another table, by column name? (The multiplier table has a column with the column names and a second column with the multipliers to apply to each column in the other table. Not all columns have a multiplier.) I can get as far as adding the multiplier to the data table in its own row, but then I'm stuck. I know I can do it...
dlifke

Discussions |
Mar 11, 2022 10:30 AM

2226 views | 3 replies
How can I trap an attempt to write to an open file?

Hi - I have a JSL script that prompts the user to save a selection of JMP graphics that have just been generated by an analysis directly to a PowerPoint presentation. The user is likely to want to inspect the resulting slides immediately, so I don't want to close the PowerPoint file automatically - but if the user then tries to append any more graphics to it with a second run of the script, they'...
DMR

Discussions |
Mar 9, 2022 11:33 AM

2196 views | 3 replies
getting a string from a list, where string contains defined text

Hi, can someone help me please? I have created a list that looks something like that:{"C1234_here_is_some_text", "C1235_here_is_some_other_text", "C1236_you_get_the_idea", ..., "C2000_still_dont_ends_here"}I want to get the complete string of the list where the first part of the string (e.g. "C1234") is "C1999".Whats the correct code here?Thank you in advance
sebbeyer

Discussions |
Mar 7, 2022 6:14 AM

1216 views | 1 replies

Previous
Next

Latest Discussions

getting a string from a list, where string contains defined text

Hi, can someone help me please? I have created a list that looks something like that:{"C1234_here_is_some_text", "C1235_here_is_some_other_text", "C1236_you_get_the_idea", ..., "C2000_still_dont_ends_here"}I want to get the complete string of the list where the first part of the string (e.g. "C1234") is "C1999".Whats the correct code here?Thank you in advance
sebbeyer

Discussions |
Mar 7, 2022 6:14 AM

1216 views | 1 replies
How to make time duration responsive to graph axis limits?

Hello, I have a datatable that consists of:absolute date-timeduration in seconds from first timestampdatapoints associated with each date-time When I plot the datapoints I often place duration on the X-axis and then crop / filter the X-axis to a period of interest. However when cropping the X-axis in the graph builder the duration no longer starts at "zero". What is the simplest way to always star...
sanford78AQH

Discussions |
Mar 6, 2022 9:00 AM

999 views | 1 replies
Can Web reports be grouped ?

Hi, I have many Web reports and I would like to create for them level structure, which will group them similarly as here JMP HTML5 Examples Every help highly appreciated!Thanks,Li
Li78

Discussions |
Mar 3, 2022 12:29 PM

1474 views | 2 replies
A Cringeworthy Statistic Statement: #3 in a series

Welcome back for the third Cringeworthy discussion topic! Many thanks to those that contributed to the first two topics. Please feel free to join this discussion as well! Today's Cringeworthy Statement should be obvious, though you all have surprised me with great insights in the past that I hadn't considered! Here it is: An engineer is tasked with running a test on a particular process ...
JerryFish

Discussions |
Mar 1, 2022 11:12 AM

5495 views | 11 replies
How to loop through column and plot variability chart

Hi, Need help here :'(
I want to create a universal script that would enable me to plot the same var chart with different column output.
For example:
I have two table

Table 1

Linkforcetemppressurelevel150882-260701-340893-450881-
Table 2Linkforcetemppressuretimelevel150882532607016434089315545088144 My Var chart would be :
X (:Link)
Y (:force, :temp, :pressure, :time, :level)

How do i create a script t...
DwantedXZ

Discussions |
Feb 28, 2022 10:44 PM

1425 views | 2 replies

Previous
Next

Latest Discussions

Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

907 views | 0 replies
JMP > GraphBuilder > Parallel Plots >River / Sankey Plots > Maximum Items?

Hi JMP Community, I just came across an odd behavior in GraphBuilder with the Parallel Plot > Sankey Plot. If I limit the input to a maximum of 66 rows, the plot looks good. However, if I bump the number of rows to 67 or more,the output is no longer useful: no annotations: Is there a trick to maintain the axis annotations as shown in the first plot? Thanks. Best, TS
Thierry_S

Discussions |
Dec 9, 2021 3:30 PM

3239 views | 0 replies
Permutation Tests and Monte Carlo Cross Validations Using the Simulation Platform

I'm trying to do permutation tests and Monte Carlo Cross Validations with the Iris sample dataset as a MWE for our dataset. I'm not sure if I'm doing things and interpreting output correctly. 1) Create New Formula Column (Random->Sample Without Replacement) for the Species Column for Permutation Test. 2) Create a Validation Column (0.75/0.25 split) and a new Formula Column (Random->Sample Withou...
mjmg

Discussions |
Dec 1, 2021 7:53 AM

1009 views | 0 replies
Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...
Technician

Discussions |
Oct 26, 2021 11:04 AM

1325 views | 0 replies
Get (x & y) intercept values from linear fit of the linear region of a curve/data and store them in a new column

I have JMP data table with data from several parts for which a Capacitance 'C' has been measured as a function of reverse voltage 'V' (0 to -5 V in -0.1V step). A plot of [1/C]^2 vs V has a linear part for small reverse bias (say from 0 V to -0.5V and data is available at 0, -0.1, -0.2, -03, -0.4 -0.5 V within this range). How to do a linear fit to the points between 0 to -5V for each part, extrac...
Neo

Discussions |
Oct 22, 2021 10:15 AM

785 views | 0 replies