break a single column into multiple based on empty row or specific character
Hi, can someone provide advice? I have a column with structure below: 1 2 3 a b c d e f xx yy zz is it possible to divide to multiple columns based on empty row (or...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, can someone provide advice? I have a column with structure below: 1 2 3 a b c d e f xx yy zz is it possible to divide to multiple columns based on empty row (or...
Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements. I have a binary test that detects the presence of bacteria in water, if it's po...
For example, Big Class.jmp The calculation steps are: if(row()>30,contains(:height[Index(1,30)],abs(:height[Index(1,30)]-:height)<3)) If the number of lines is greater than 30, compare ...
Hi, I am having some trouble with the following. I have a group of custom output, grouped by a variable, that I need to be in a single report. I get the output that I need. However, I...
Hello, this may be a simple question. I am trying to analyze e relationship between Adjusted Variable and Variable of Interest. I want to calculate adjusted variable data by ag...
Hi, can someone provide advice? I have a column with structure below: 1 2 3 a b c d e f xx yy zz is it possible to divide to multiple columns based on empty row (or...
Hi, I'm trying to calculate the sample size required for my test to meet the sensitivity and specificity requirements. I have a binary test that detects the presence of bacteria in water, if it's po...
Hello, this may be a simple question. I am trying to analyze e relationship between Adjusted Variable and Variable of Interest. I want to calculate adjusted variable data by ag...
Graph Builder is fantastic, it's one of the killer features of JMP. Does it have a ruler tool buried somewhere? A way to measure the distance between two points? For al...
Hi, I am looking for some advice using SPC to monitor Actual Yield vs Planned Yield. Plotting the SPC to measure Actual Yield (%) alone is straightforward, and normally when there's a ...
Hi, I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://w...
Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time c...
I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14....
Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out t...
I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn to fit models using variable sel...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...