Delete all columns that have zeros in all raws
Well, that is what I need to do.I tried to look for similar scripts but I have not found the solution.Thanks in advance. Manel
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesWell, that is what I need to do.I tried to look for similar scripts but I have not found the solution.Thanks in advance. Manel
I would like overlay points from one data table onto a contour plot from a second data table without joining the data tables. I want to maintain the coloring and other properties from the points. I have tried to use the Copy/Paste Frame Contentents feature, however it provides the points but not the colors assigned to the points. Below is an example use JMP sample Data A contour plot based on Citi...
Hi all,I'm trying to fit a model to full factorial experiment (4 factors, curvature likely in all). I have a tight data fit (RSq=0.81). However, the prediction profiler is not generating any graphs. We didn't add centerpoints across all factors in the first pass of the experiment. Two of the factors we have center points for. If I simplify the model for screening and treat the data as continuous, ...
Hello, I'm trying to figure out a way to fill in missing cells that should have values that are based on other cells. In my table, some of these cells are properly filled in, while others aren't. Here's a rough example Column 1Column 2Column 31aa'2bb'1aa'3cc'2 3 1 3cc'2 In this example, every row that has a '1' in the first column should have an A, and then an A' in the 2nd and 3rd column, re...
Hello,Since my last question a few days I have come a little further with my script.To complete the first step I would like to combine the reports (in 3 Windows) in one Report (1 Windows).How can I do this ... See line 51 ffAnd how can I save this Report automaticly named by data_file name (first 10 characters) AND _Baseline (if select more than one Month) OR _Monthly (with selected Month)? ... se...
Hello, I'm trying to figure out a way to fill in missing cells that should have values that are based on other cells. In my table, some of these cells are properly filled in, while others aren't. Here's a rough example Column 1Column 2Column 31aa'2bb'1aa'3cc'2 3 1 3cc'2 In this example, every row that has a '1' in the first column should have an A, and then an A' in the 2nd and 3rd column, re...
I am doing an ANCOVA analysis. I have a response variable water status which is continuous and I have soil moisture which is continuous as the predictor. I have a categorical variable which is variety and I desire to compare the slopes of each Y vs. X between different varieties to show if the linear regression has the same slope among varieties. The ANCOVA done on JMP and mentioned on this websit...
Hello JMP Community, I am trying to split a dataset into Test and Control for a marketing experiment. The data set is unique at the customer id and has a million rows. Both the new datasets must be balanced using two parameters which are annual customer spend (YTD) and last quarter spend (QTD). These parameters are represented in two columns. I am unable to figure out how to create a stratified/b...
I'm working on a project that will take some data and export a csv file. I got it to save successfully to the local drive but I was wondering if there is a way to have it save to a different network drive, and what I would need to do this. Thanks
Previously there was a thread on fixing the Weibull beta as well as the p-factor in a Defective Subpopulation analysis. https://community.jmp.com/t5/Discussions/Life-Distribution-Fixing-p-and-fixing-Weibull-beta-in-DS-Weibull/td-p/43681 I have 3 "flavors" of the same population but with different stress conditions. Theoretically if we have the same failure mechanism then the Weibull beta should be...
I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
Dear JMPers, (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.) I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...