Conversion of AM/PM to 24 hrs format
Hello JMP user,Can you please suggest how to convert the time AM/PM to 24 hrs format.In below table, column 1 is in "Character" Data Type and I want to convert it in 24hrs (h:m:s) format. Regards,Chandan
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHello JMP user,Can you please suggest how to convert the time AM/PM to 24 hrs format.In below table, column 1 is in "Character" Data Type and I want to convert it in 24hrs (h:m:s) format. Regards,Chandan
HI JMP users, am looking for your help to make identical clone of a column through JMP scipt.I don't want to select the "Date" column to make a identical column instead script should be able to recognize "Date" column and make a clone column. Regards
Anyone have tips for organizing lot genealogy in JMP? For example, DP batches that contain many (different types and lots) of excipients. And the excipients have COA values that we want to track.
I'm assuming just multiple row entries for a DP lot on the left, working to more granular information in columns to the right. Is this the best way to track and visualize?
In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database(
"DSN=Test;DBQ=filelink\filelink\file.mdb",
"SELECT * FROM [file]"
)
Hi All,
I want to create a column based on :Client_ID and how many times ( a number of sequence is counted as 1 count only, see the the :Comment column) it is appearing in the data set. My requirement is :Final Requirement and would be happy to have :Required Column 1 as well. I can not re-arrange/sort the data.Any help please ?Many thanks, -HSS
Anyone have tips for organizing lot genealogy in JMP? For example, DP batches that contain many (different types and lots) of excipients. And the excipients have COA values that we want to track.
I'm assuming just multiple row entries for a DP lot on the left, working to more granular information in columns to the right. Is this the best way to track and visualize?
In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database(
"DSN=Test;DBQ=filelink\filelink\file.mdb",
"SELECT * FROM [file]"
)
Let's say I have a 3 column Line Up box with some display boxes, and then as a second row I have an Unlineup Box with a Graph Builder inside.Example can be seen by running this script:dt = New Table( "DEMO",
Add Rows( 10 ),
New Column( "Category",
Character,
"Nominal",
Set Values( {"A", "A", "A", "A", "A", "B", "B", "B", "B", "B"} )
),
New Column( "X",
Character,
"Nominal",
Set Val
...
Hi, I am developing a cell culture medium based on 4 prototypes. These 4 prototypes are basically contain same components but at different level, Prototype 1 is lean, prototype 2 is rich in amino acid, prototype 3 is rich in vitamin and prototype 4 is rich in trace element. I will mixture different level of the 4 prototypes to have a new mixture media.I understand this is a mixture of mixtures des...
I don't seem to be able to get the reference frame to show up on the resulting graph by selecting a preference (see screenshot)? Is this a feature, a bug, or my ignorance of what option to select? (I can turn it on using the Little Red Triangle [because that's my friend!].)
Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
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...