JMP User Community

Latest Discussions

Import only a part of a large csv file to JMP

I have a large csv file containing > 50million rows of data for all 50 states of the US. How can I import only part of the data to JMP (e.g., data for California only)?One way to do it is to open the cvs file in JMP and then filter out the data for California, but this takes forever. So I was wondering if there is a way to filter the data *before* importing it to JMP? I guess this can be done with...
shasheminassab

Discussions |
Sep 12, 2020 5:25 PM

1907 views | 1 replies
Graph Builder "Copy Graph" button

Why is there no "Copy Graph" button in Graph Builder? It seems like the most intuitive thing to have in the interface because in almost every case (for us at least), once we have a graph we like, we want to copy/paste it to PowerPoint, Word, etc. I was going to post this the other day, but then I thought -- what if just ctrl-c (cmd-c) copied the graph. So I tried it and it worked! But when I wen...
BHarris

Discussions |
Sep 11, 2020 2:27 PM

9237 views | 4 replies
duplicating elements in list

What's the easiest way to duplicate elements in a list myListA = {"y"}; //Result I need: myList = {"y", "y"}; // This should work with an arbitrary number of elements in the list myListB = {"y1", "y2", "y3"}; //Results myList = {"y1", "y2", "y3","y1", "y2", "y3"};
FN

Discussions |
Sep 11, 2020 11:43 AM

2279 views | 3 replies
Finding the maximum of a column by matching another column condition

Hi every one,I have to find the maximum value in a column (:PMA Counter) after checking the condition in another column (: Condition). the condition column has "After" and "Before" characters for the different rows. I want to pick those which are "After" and fin the maximum of (:PMA Counter) between them. I already use the below script but it is not working and only give me the Max without consid...
Mikasa

Discussions |
Sep 11, 2020 9:09 AM

6949 views | 11 replies
Closing a hidden data table when closing a figure

I have a few hidden data tables that I only show to the user via some plots. As they are hidden, they accumulate in memory (as many times as the user calls the function in the toolbox). Is there a way to embed the JSL action (closing the invisible table) when the user closes the figure created?
FN

Discussions |
Sep 11, 2020 6:55 AM

2297 views | 2 replies

Previous
Next

Latest Discussions

Import only a part of a large csv file to JMP

I have a large csv file containing > 50million rows of data for all 50 states of the US. How can I import only part of the data to JMP (e.g., data for California only)?One way to do it is to open the cvs file in JMP and then filter out the data for California, but this takes forever. So I was wondering if there is a way to filter the data *before* importing it to JMP? I guess this can be done with...
shasheminassab

Discussions |
Sep 12, 2020 5:25 PM

1907 views | 1 replies
Graph Builder "Copy Graph" button

Why is there no "Copy Graph" button in Graph Builder? It seems like the most intuitive thing to have in the interface because in almost every case (for us at least), once we have a graph we like, we want to copy/paste it to PowerPoint, Word, etc. I was going to post this the other day, but then I thought -- what if just ctrl-c (cmd-c) copied the graph. So I tried it and it worked! But when I wen...
BHarris

Discussions |
Sep 11, 2020 2:27 PM

9237 views | 4 replies
How to change legend names in JSL (in Graph Builder)?

I get a lot of data in a CSV file (many columns, many rows) and am working on a basic template in JSL to standardise the generation of graphs. (Rescaling the axes, renaming the axes, standardising the colour of the lines etc...) On the average I can get one CSV file per day so I want to put the data into a JMP Data table, run the script and have the graph output all automated.My JMP file has by de...
scottahindle

Discussions |
Sep 10, 2020 5:09 AM

10939 views | 9 replies
Tolerance Interval for Regression

Is there a way to calculate the tolerance interval for a simple univariate regression in JMP? There is only prediction and confidence intervals options available. Thanks
nguyendv0610

Discussions |
Sep 10, 2020 2:15 AM

2028 views | 1 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1482 views | 0 replies

Previous
Next

Latest Discussions

Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1482 views | 0 replies
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

1014 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

1141 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

1544 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

1734 views | 0 replies