JMP User Community

Latest Discussions

How do I parse large json from an API?

I am trying to create a data table from an API response but the JSON that is output won't process and I think the file is too big. It's about 20 MB and the final data table is ~7000 rows and ~115 columns. Is this just too big to parse? I also have the option of getting a csv file from the API or output as a text string. I work with the developers that wrote the API so we can make it output wha...
MQ_Smith

Discussions |
Apr 29, 2022 12:38 PM

1764 views | 3 replies
JMP 16.2 Equivalent to Excel PERCENTILERANK Function?

Would like to find the percentile of a number within a data set. What percentage of values are above/below a certain number? Other than eyeballing a CDF or Prob Dist chart is there an existing path to get this number or is this a JSL task?
WoHNY

Discussions |
Apr 29, 2022 12:12 PM

3284 views | 8 replies
Survival

I have done scripts before where I do not put columns into the script so that when the script is executed, it brings up the platform and lets them put the information in, such as: Fit Model( Y( ), Effects( ), Personality( "Standard Least Squares" ), Emphasis( "Minimal Report" ), Run( :height << {Summary of Fit( 1 ), Analysis of Variance( 1 ), Parameter Estimates( 1 ), Plot Actual by Predicted( 1...
lisamaley

Discussions |
Apr 29, 2022 10:13 AM

1055 views | 2 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

716 views | 0 replies
JMP script for Joining data tables using contain function

Hi All,

I have 2 data table shows as below, need to join based on 2 matches, were place will be 100% match and the second column to be matched will be a truncated version from first Please help here to join data table based on 2 column, taking 2 column under consideration
jinsejoseph

Discussions |
Apr 29, 2022 4:16 AM

1061 views | 1 replies

Previous
Next

Latest Discussions

How do I parse large json from an API?

I am trying to create a data table from an API response but the JSON that is output won't process and I think the file is too big. It's about 20 MB and the final data table is ~7000 rows and ~115 columns. Is this just too big to parse? I also have the option of getting a csv file from the API or output as a text string. I work with the developers that wrote the API so we can make it output wha...
MQ_Smith

Discussions |
Apr 29, 2022 12:38 PM

1764 views | 3 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

716 views | 0 replies
Is there a function to convert a character to its ASCII equivalent?

Is there a function to conver a character to an ascii number? In the end I need to translate a character based column in data into its numerical equivalent. They always happen to be 1 or 2 digits. So effectively "A" becomes 1"Z" becomes 26"AA" becomes 27"AB" becomes 28 etc. So say DIE_COLUMN = "CA" I want to return 79 I've come up with the following thoroughly ugly formula... but if there was ...
LikelihoodFaces

Discussions |
Apr 28, 2022 11:36 AM

2575 views | 3 replies
PLS and latent variables structure

Hello, I'm using JMP Pro to conduct a Partial Least Squares analysis and I'm wondering if there is a way in JMP to explore the structure of the latent variables, like which variables have a high weight on each latent variable. Thanks!
Moukanni

Discussions |
Apr 28, 2022 10:57 AM

1327 views | 2 replies
How to detect outliers

Hi all, I would like to make a script to detect outliers based on my data population.Based on the image below, I tried to calculate mean of all pockets from 0 to 6 and applied method ((Mean +- (3*sigma)) to find outliers. By direct observation, Pocket 2 has a lot of outliers. However, in case the value of variation data points on Pocket2 is within ((Mean+-(3*sigma)), my method cannot detect them a...
PhamBao

Discussions |
Apr 28, 2022 9:00 AM

1186 views | 1 replies

Previous
Next

Latest Discussions

JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

716 views | 0 replies
How to create a graph builder box plot with mean values, and including the "group X" variable in the legend

I'm using JMP 16.2.0 and I'm trying to automatically generate a graph builder with box plots and their mean values with the group X variable as the color. I'm using a bar chart with style=floating to display the mean value (inspired by this topic)My current graph:This is almost what I want, except for a few things.1. I'd like the Group X variable (Recipe) to be visible in the legend as well. One w...
mvanderaa1

Discussions |
Apr 20, 2022 4:13 AM

2575 views | 0 replies
Error When Trying to Create User to Access the JMP Virtual Lab

While taking the Exploratory Data Analysis module, it is time to practice. However, when trying to access the JMP Virtual Lab, I cannot get past the "Create User" option. JMP VIRTUAL LABTo use the Virtual Lab, please select the Create User link below. If you would prefer to use software on your own machine, please select the Download Data link below.
Create User Download Course Data Clicking the C...
TielsForTheWin

Discussions |
Apr 14, 2022 10:48 AM

814 views | 0 replies
Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

859 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

614 views | 0 replies