JMP User Community

Latest Discussions

Import CSV file and clean data by removing letters

Hi JMP Community,
I struggle with a csv import. Unfortunatly I get only that weird csv format from my datasource. At the end I want to use actual voltage and actual current and the time as steady values.

Can you please give me some hints how to import the csv correctly?
Thanks in advanceNorbert
NickelNorbert

Discussions |
Feb 26, 2025 3:56 AM

1255 views | 4 replies
Is it possible to achieve this type of plotting using JSL?

Plotting in a specified column: Plotting data from multiple columns in the same row as a graphic within this column.It seems the effect of the new column manager is not like this.Thanks!
lala

Discussions |
Feb 26, 2025 1:59 AM

2073 views | 17 replies
Using JSL script to sort a column in a data table using List Check or Value Order property

Hi all, I'd like to use the List Check feature or the Value Order column property to custom sort a column in a datatable. This data table is created from a subset of another data table, but I am unable to get the property to custom sort the values in the data table. The relevant commands I'm using is as listed below: dt_summary_table = (Data Table( "Name of table" )) << Make Into Data Table; /...
JmpStatistician

Discussions |
Feb 25, 2025 9:57 PM

4025 views | 5 replies
Color out of spec value using script.

How can I do "color out of spec" using script? Log do not record anything when I do this.
ConfidenceOwl94

Discussions |
Feb 25, 2025 12:34 PM

699 views | 1 replies
How do I convert Date in seconds to use it in date difference method

I have a code section where I have to create new column hours by finding the difference between the current date and the minimum date (initial date) . But unfortunately i have tried a lot of things but i could not get to the solution. // Convert "Date" from Character to Date format col = Column(dtCombined, "Date"); col << Data Type("Numeric", Informat("y/m/d"), Format("d/m/y")); col << Modeling...
HV0508

Discussions |
Feb 25, 2025 8:35 AM

1355 views | 7 replies

Previous
Next

Latest Discussions

Is it possible to achieve this type of plotting using JSL?

Plotting in a specified column: Plotting data from multiple columns in the same row as a graphic within this column.It seems the effect of the new column manager is not like this.Thanks!
lala

Discussions |
Feb 26, 2025 1:59 AM

2073 views | 17 replies
Ignored preference

In JMP Pro version 18 (Windows 10 Pro) I've selected a different default color for my histograms under the Distribution Platform, but said histograms appear to ignore this preference and appear with the default (somewhat blah) color. What am I doing wrong (if anything)? It works fine on my Mac (which I rarely use).
sfigard

Discussions |
Feb 25, 2025 8:13 AM

1173 views | 6 replies
Date time stamp form excel failed

Value original Excelfile format date-time: 17.09.2021 10:37:24
Value after JMP-Import type STRING: 44439,1151041667Value JMP after correcting the type to date/time: 01.01.1904 12:20

That's a big problem and up to now I haven't found a solution. There are several columns with same issue.
It would be graet if somebody has a solution or tip.

Mike_S

Discussions |
Feb 25, 2025 4:30 AM

1053 views | 4 replies
Is it possible to connect to a IBM DB2 database without using ODBC?

Hello, We use an IBM DB2 database through an SSL connection. The OCBC connection to the DB works well, but is quite complex to setup for the majority of the users. If a software can use a "type 4 db2 connection", odbc is not required. Only a "connection string" is sent directly to the remote server. The parameters of this string are usually configured directly in the software. A connection co...
Graudet

Discussions |
Feb 25, 2025 2:57 AM

1944 views | 6 replies
Results of EMP test not showing

Hi all,I am currently running Measurement System Analysis from the "Analyze" Tab, but the EMP Results that once showed up do not show up anymore. There's just a blank space where they are supposed to be (attached). Would anyone know how to make them reappear?
DualMongoose896

Discussions |
Feb 25, 2025 1:57 AM

531 views | 1 replies

Previous
Next

Latest Discussions

query text files from zip folder in Azure blob file system secure (ABSS) url

Hi All,I wonder if anyone has the experience to query text files from zip folder through Azure blob file system secure (ABSS) url?
the url looks like format below. If you do, can you share some script lines how to connect to the url at least?

abfss://filesystemname@accountname.dfs.core.windows.net
dadawasozo

Discussions |
Feb 18, 2025 1:37 PM

391 views | 0 replies
Streamlining Data Workflows With JMP & MATLAB

Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
brycerjs8

Discussions |
Feb 18, 2025 7:07 AM

480 views | 0 replies
Question About F-Tests in GLMMs with Binomial Errors

Hi,
I have a question regarding Generalized Linear Mixed Models (GLMMs) in JMP pro. Most statisticians consider it inappropriate to use F-tests or t-tests to evaluate predictor contributions in GLMs or GLMMs with binomial errors. This is because F- and t-tests are based on sums of squares, which assume normally distributed residual errors.
While using a logit link function helps linearize the relati...
LanaMilana

Discussions |
Jan 17, 2025 2:21 AM

703 views | 0 replies
How to adjust the size of R plot imported with get R graphics(); ?

I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want? R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...
CountableModel1

Discussions |
Jan 15, 2025 4:01 PM

523 views | 0 replies
Logistic regression - confidence bands.

beimar_iriarte_

Discussions |
Jan 10, 2025 12:10 PM

550 views | 0 replies