JMP User Community

Latest Discussions

How to drop all digits from string with exceptions using Regex?

I want to clean up a free text filed column for text analysis and am trying to drop all digits except when followed by a specific letter. In the example below, I want to drop the first numbers but keep both 120f and 119 f, as they are meaningful values.Using the following regex:Phrase = "14.300.114 .temperature is not 120f but 119 f..."; Show( Phrase ); Regex( Phrase, "\d+([^\d+(f|\sf)])", "", GL...
Mo

Discussions |
Sep 9, 2020 1:15 PM

2002 views | 2 replies
Help doing a table transform and converting a timestamp?

so I've got a data table from a sensor that I am not quite sure how to get formatted correctly. It's a light sensor that outputs voltage readings. The first column in the table is the wavelength measured and then there's 100+ columns for each time instance it measures data. How would I go about transforming or pivoting this correctly? Would just a Table Transpose be the correct activity? Next, adv...
aliegner1

Discussions |
Sep 9, 2020 12:58 PM

4950 views | 11 replies
JSL script for summary table with for loop

Hello, I am creating a script for summary table with a for loop as there are multiple parameters from the PCM test. The script I have created was based on the JSL script generator and replace the mean () with colNames [i]. It did work but poped out 100s of data table for each parameter. Previously, I had a similar issue with the graphs and a gentleman replied with the solution nw = new window(). I...
chungman89

Discussions |
Sep 9, 2020 6:15 AM

1923 views | 2 replies
What type of Geographic Coordinate system does JMP use?

Hi, I am trying to map coordinate data from Korean Government into JMP; because the data set given is much bigger and has detail resolution of map.However, I have no idea how to convert the X-Y Coordinate to Longitude/Latitude system as used in Google or JMP.So far as I am aware, the coordinate of X-Y is given in EPSG:5174.This is the sample data from the file. [XY File]Shape Part X Y
1 1 197597.73...
joelahn

Discussions |
Sep 8, 2020 7:28 PM

1835 views | 3 replies
analyzing nominal data columns with multiple comma-separated entries

JMP experts, I remember an online webinar last year where the presenter was able to graph, or analyze, data with regard to a nominal data column having multiple entries that were separated by only a comma (no space). Some variables were in multiple rows, but not all. This may have been a webinar (as I recall while typing this) where the column has something to do with a wide variety of personali...
aadecarlojr

Discussions |
Sep 8, 2020 2:08 PM

1642 views | 1 replies

Previous
Next

Latest Discussions

Histograms in column headers

Our group just got JMP v15.1 installed on our systems today, so it was my first chance to try it out. At risk of being gratuitous, I have to say the new histograms in the column headers is probably the best and most surprisingly-useful-and-well-implemented feature I've seen in a piece of software in a very long time. I was delighted -- and even giddy -- when I realized I could click on the bars i...
BHarris

Discussions |
Sep 8, 2020 12:54 PM

2803 views | 4 replies
How do Space Filling designs automatically generate a run number? Also, can someone please explain the "discrepancy" and "MaxPro" statistics?

Hi, I’m a biological scientist aiming to physically execute a space filling DoE using Fast Flexible filling to test 11 factors (10 continuous and 1 categorical) to characterise an enzymatic reaction. When I generate the design I see that JMP has populated the run number box with 110 runs. If I add another factor, this goes up to 120 and if I reduce a factor it decreases 100 and so on. Can anyone ...
schilakwad

Discussions |
Sep 8, 2020 8:52 AM

1366 views | 1 replies
X axis not linear with Variability Chart or Oneway graph

Hello, When using Variability Chart it is not possible to allow linear representation of X axis.When using Oneway, with Display options --> X axis Proportional, nothing happens, my X axis always with same intervals not linear with X axis values.If I use Graph builder automatically the X axis is shown in linear mode.Can you help to solve this issue, in effect I do not see with Variability chart the...
ArmagVinc

Discussions |
Sep 8, 2020 7:09 AM

3880 views | 9 replies
Detect outliers in a dataset with categorical variables

I have a large data set with categorical survey data from > 800 participants. There are 10 categorical variables with 4 nominal levels each. Is there a jmp method for assigning/detecting outlier participants?
frankderuyck

Discussions |
Sep 7, 2020 12:20 AM

4523 views | 3 replies
Assign different spec limits from a column rows to another column rows as a property

Hi I know Spec limit has been discussed here different times but I could not find a solution for my question I have a column with different product and I group the same products but each group has different spec limit. all the spec limits are in 2 columns (Upper, lower limit). I like to assign each row of the product column to the same row in the spec limit column. Could you please tell me how ...
Mikasa

Discussions |
Sep 4, 2020 8:24 AM

4227 views | 14 replies

Previous
Next

Latest Discussions

order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

717 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

801 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

975 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1269 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1122 views | 0 replies