How to add final test check column.
I have a table where some products were tested multiple times. I want to flag the last run by '1' in a new column.
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have a table where some products were tested multiple times. I want to flag the last run by '1' in a new column.
Hello guys,
I started using jmp project recently. I want to write a script which loops through all reports in the project and perform a action and update the report. Any idea on how to go about this kindly support
Thanks in advance
This removes html structure files quickly.Thanks!太阳的微笑
原创 大v专访 2022-09-14 20:30 福建
淘时刻
人划线
Hi All, I have a script that runs several SQL queries in parallel to get around the character limit in the ODBC driver/SQL server since we frequently need to pull in data for WHERE clauses containing many thousands of strings, e.g "SELECT * FROM [Table] WHERE [id] IN ('id000000001','id000000002',...'id000010000')". My method for doing this works fine, (iterate through a list of queries doing <<R...
Most of the recent JMP videos I've seen use JMP 18. The JMP website says JMP 18 is "Coming March 19". Is JMP 18 available? I can't seem to find it anywhere. If it is available, how do I upgrade?
Hi All, I have a script that runs several SQL queries in parallel to get around the character limit in the ODBC driver/SQL server since we frequently need to pull in data for WHERE clauses containing many thousands of strings, e.g "SELECT * FROM [Table] WHERE [id] IN ('id000000001','id000000002',...'id000010000')". My method for doing this works fine, (iterate through a list of queries doing <<R...
Most of the recent JMP videos I've seen use JMP 18. The JMP website says JMP 18 is "Coming March 19". Is JMP 18 available? I can't seem to find it anywhere. If it is available, how do I upgrade?
Hi all How to calculate the Total Qty if they have the same code? I am currently using Col Sum(:Qty) but it is getting the sum of all column values. I just want the sum of values with the same code & date DateCodeQtyTotal Qty10-23-23004910-23-23005910-23-23016610-24-23033310-24-23044410-25-23056810-25-230528
I tend to work with the same types of data every day. Every time I load a file, JMP sets some columns as "Continuous" that really work better as nominals. Is there a way to tell JMP that if it sees a column with a specific name, e.g. "case_id", that it should always flag it as nominal? I know scripts can do this, but having to run a script every time I open a file has gotten a bit tedious.
Hi community, I am working on a formulation work. I got initial 3 by 3 Design as below with replicates. Then I got decet predictive model. Below is the controur plot with raw data vs plot predicted by the model. They look alike except the region where there is no data points (white space), Now I want to optimize this formulation by further looking into the high performing formulation (both upper ...
HiWe're doing a study regarding whole number ordinal data, answers being 0 to 4. It probably being MAR and not knowing the probability of each response, made us wonder how to do multiple imputation of this data. A post showed:go to analyze > consumer research > categorical But we're stuck...Thank you in advance!
Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...
When I run cluster analysis --> LCA with ordinal variables (numeric, ordinal), the probability formula appears to be treating the variables as nominal, rather than ordinal. For each variable, there are 5 levels (i.e., 1-5). If being treated as ordinal, wouldn't the probability formulas reflect an order for each level where 1 may have the smallest probability and 5 the largest? As you can see below...
Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?
Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer(
Text Columns( :col1)
);
obj << Stemming("Stem for Combining");
obj << Add Recodes(
{{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl
...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
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...