Delete Duplicate rows
Hi, I have a datable that I want to delete rows on a duplicate value in a col. Thank you,Rami
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I have a datable that I want to delete rows on a duplicate value in a col. Thank you,Rami
Here is my code: path = "/users/BOT/Test_files/";
Set File Search Path( mypath );
// filter out all csv files in the path that contains "Pass" && Not contains "Conditional_Pass" or "Fail" in file name
y = Files In Directory( mypath );
For( i = N Items( y ), i > 0, i--,
If( (Ends With( y[i], ".csv" ) & Contains( y[i], "Pass" ) & Not( Contains( y[i], "Conditional_Pass" ) ) & Not( Contains( y[i],
...
I am writing a script that uses the Prediction Profiler inside of the Fit Least Squares Platform. In particular, I am making use of the Maximize and Remember option, which saves the factor settings into the Remembered Settings Outline Box. After I save certain combinations, I want to clear out the settings. If I would be using JMP manually, I could simply go to the red triangle by "Remembered Sett...
Hello, Using JSL in JMP18 I can create new folders in both my personal space and in other spaces on JMP Live using the 'Create Folder' function. When I create folders in my personal space, I can use the JSL 'Find Folders' function to list all existing folders first and check if my new folder already exists. I could then assure unique folder names trough JSL.The default behavior of JMP Live is to c...
I have multiple measurement for a same part number in a raw. How can I get last entry in a one column.
I am writing a script that uses the Prediction Profiler inside of the Fit Least Squares Platform. In particular, I am making use of the Maximize and Remember option, which saves the factor settings into the Remembered Settings Outline Box. After I save certain combinations, I want to clear out the settings. If I would be using JMP manually, I could simply go to the red triangle by "Remembered Sett...
Is there a way to select multiple options in graph builder (eg red triangle next to "GRAPH BUILDER" So for example can I select SHOW - legend and SHOW title sequentially without going of the option window
I signed up for JMP student access and recevied the license information. On the license information page, when I click on the hyperlink "JMP Subscription Installer Download via MyJMP", I am getting an error message stating the following. How do I resolve this issue as my graduate class starts in 3 days? "Thank you for your interest in accessing My JMP. We apologize for any inconvenience, but we ar...
Hello!
I am currently facing an issue while importing an Excel file that contains a date column into JMP. This column includes two different formats: "DD/MM/YYYY" and "DD/MM/YYYY hh:mm". The "DD/MM/YYYY" format should be interpreted as midnight, i.e., "DD/MM/YYYY 00:00". However, when I import the file into JMP, whether via script or the GUI, whatever import option used, JMP seems to import missing...
here you find 54 individual data, exponentially distributed.JMP analyses the data and provides a STRANGE Control ChartWhy?See the attached fileFausto Galetto
New to PLS and confused as to the following: when I run the PLS and ask for results for two factors, I get two rows for each Y (in this case metabolites). I must be interpreting the results wrong, as I do not expect two rows for each metabolite, with a total of four different scores, two apparently corresponding to each factor.
1. Reset the password: Password not set successfully2. User name and password are not changed How to solve the problem?
In JMP 18 a locked data table does no longer allow saving a script. This is a disadvantage in my working process. In my view locking the data table should protect the data only. W. Koch
Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Hello , i need data about middle east country companes for my PhD thesis،Which sites are valid for collecting information from Middle Eastern companies and can I use them for data collection?
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...