JMP User Community

Latest Discussions

Delete Character from String In specific position

Hello, I am looking to create a script to remove a character from a string while ignoring the same character earlier in the string. For example, from a data table I have a special DateTime of YY/MM/DD/hh:mm and wish to remove the third / (ie character 9). Thank you for any help, Luke
LukeFarrell

Discussions |
Oct 28, 2021 8:37 AM

4525 views | 3 replies
While changing the data type to numeric column data changed from 00000 to 0,

Hi Team, Need help to avoid the round off,
like when changed from character to numeric column value changed from 0000 to 0
please suggest some solution ,i need the same entire string for analysis(view in My Videos)
jinsejoseph

Discussions |
Oct 28, 2021 7:47 AM

1214 views | 2 replies
Executing series of data pulls in scheduled scripts when one or more DB servers are down

All, I have a script that pulls various databases around the world. This script is scheduled and automated. Meaning that it does what it does, saves all the tables, closes JMP and task is then finished. However, from time to time one or two DBs are unresponsive. LDAP server is down and doesn't accept my password, or some DB maintenance etc.In this case I get a pop-up window like that:Even if I'm ...
miguello

Discussions |
Oct 28, 2021 6:43 AM

843 views | 1 replies
Is there a way to constrain a model so predictions are limited within a certain response range?

Hi, I have a space-filling DoE with a response that ranges from 0 to 100%, is there a way to constrain the model (specifically a Gaussian Process model, if possible) so that model predictions are don't go below 0 and above 100%? I'm using JMP Pro 15, if that helps. Thank you, Shama
schilakwad

Discussions |
Oct 28, 2021 6:23 AM

1747 views | 4 replies
How to make script run for each sample in a list if there are multiple entries per sample in data table.

I have a data table where the same samples were measured multiple times (see example below). The samples are separated by their identifier. I want my script to be able to perform the same set of calculations on each sample so I can determine control limits and make a control chart for A, B, C, etc. I do not know the identifier of each sample. I already have a script that can do my calculations ...
J-Leonard

Discussions |
Oct 28, 2021 5:00 AM

2376 views | 5 replies

Previous
Next

Latest Discussions

Delete Character from String In specific position

Hello, I am looking to create a script to remove a character from a string while ignoring the same character earlier in the string. For example, from a data table I have a special DateTime of YY/MM/DD/hh:mm and wish to remove the third / (ie character 9). Thank you for any help, Luke
LukeFarrell

Discussions |
Oct 28, 2021 8:37 AM

4525 views | 3 replies
While changing the data type to numeric column data changed from 00000 to 0,

Hi Team, Need help to avoid the round off,
like when changed from character to numeric column value changed from 0000 to 0
please suggest some solution ,i need the same entire string for analysis(view in My Videos)
jinsejoseph

Discussions |
Oct 28, 2021 7:47 AM

1214 views | 2 replies
Executing series of data pulls in scheduled scripts when one or more DB servers are down

All, I have a script that pulls various databases around the world. This script is scheduled and automated. Meaning that it does what it does, saves all the tables, closes JMP and task is then finished. However, from time to time one or two DBs are unresponsive. LDAP server is down and doesn't accept my password, or some DB maintenance etc.In this case I get a pop-up window like that:Even if I'm ...
miguello

Discussions |
Oct 28, 2021 6:43 AM

843 views | 1 replies
Is there a way to constrain a model so predictions are limited within a certain response range?

Hi, I have a space-filling DoE with a response that ranges from 0 to 100%, is there a way to constrain the model (specifically a Gaussian Process model, if possible) so that model predictions are don't go below 0 and above 100%? I'm using JMP Pro 15, if that helps. Thank you, Shama
schilakwad

Discussions |
Oct 28, 2021 6:23 AM

1747 views | 4 replies
Script for removing duplicate rows

Hi, I have a script where I update a table by another one.For the final table, I would like to remove duplicate rows based on defined columns.Thereby, the row with the lower row number should be deleted. In the following you can see an example for better illustration: RowDateABCD122.10.2021110415223.10.2021215827326.10.2021325 425.10.2021471312526.10.20213256 For this table, the duplicate rows ar...
Konstantinos

Discussions |
Oct 28, 2021 4:30 AM

3044 views | 4 replies

Previous
Next

Latest Discussions

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

1175 views | 0 replies
how can I use structural equation model to make predictions?

Hi, I built a structural equation model and it works well. I would like use the model to make some predictions. Basically, what I want to do is to change the value of a variable and then JMP can calculate the values of other variables. Is there any way i can output the model equation so that I can use it to predict? Thanks.
lujc07

Discussions |
Oct 22, 2021 11:54 AM

731 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

708 views | 0 replies
Debugger report for finding bottlenecks

I'm trying to find bottlenecks in a large script with many includes. I can run the debugger to profile the script but I'm wondering if there's a better way than just looking through each included script for the highest number. I'm imagining a pareto. Anyone know a good method to analyze script performance?
vince_faller

Discussions |
Oct 22, 2021 7:31 AM

664 views | 0 replies
world map server compatibility

I have successfully used 1-2 world map servers in the past through GraphBuilder but am encountering issues recently (JMP Pro 16). I can't figure out if it's something on my/JMP's end, or the WMS themselves. For instance, the US government has all these presumably WMS-like mapping products: Note: tiled services may show up as Web Map Tile Service (WMTS), rather than WMS. Most software that can loa...
abmayfield

Discussions |
Oct 22, 2021 4:56 AM

759 views | 0 replies

Previous
Next

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

Delete Character from String In specific position

While changing the data type to numeric column data changed from 00000 to 0,

Executing series of data pulls in scheduled scripts when one or more DB servers are down

Is there a way to constrain a model so predictions are limited within a certain response range?

How to make script run for each sample in a list if there are multiple entries per sample in data table.

Latest Discussions

Delete Character from String In specific position

While changing the data type to numeric column data changed from 00000 to 0,

Executing series of data pulls in scheduled scripts when one or more DB servers are down

Is there a way to constrain a model so predictions are limited within a certain response range?

Script for removing duplicate rows

Latest Discussions

Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

how can I use structural equation model to make predictions?

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

Debugger report for finding bottlenecks

world map server compatibility

JMP Events

More on the many advantages of structural equation models