Database access
Hi, when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality? SQL formulas (rand (),txt = Substring(), myValue = a+b ) Explode Lateral View
hogiFind courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality? SQL formulas (rand (),txt = Substring(), myValue = a+b ) Explode Lateral View
hogiHi, I am trying to query data base by providing input parameter through a variable. 1] I am seeing below error for attached: a = 666.1; deleted object reference[] How do i resolv...
vharibalI have 2+ data tables with the same columns and I want to produce a graph using all the tables. Previously, I have concatenated them and used the resulting table however this produces lots of extra t...
MedianRooster10Dear community, I perform trend analyses using control charts for different products of the same family, which share common process controls (pH, manufacturing time...), but which have different spe...
Andekatxt=Get Clipboard(); New Window( "Example", sb = Script Box( txt ) ); with a toolbar Thanks!
lalaI am trying to display and/or export close to 900 graphs from a dataset using Graph Builder using JMP Pro 17.0.0 into a PowerPoint or pdf format. However, it seems like 200 graphs is the maximum JMP ...
FactorBiasFawn3I am planning to analyze circadian rhythm data and can fit it to the Savitzky-Golan smoother with a cubic degree and local cosine weighting. This provides a visual with a confidence of fit. How...
aadecarlojrI'm trying to find a way to combine the two wafer maps below. In other words, I need the X/Y coordinates to actually appear as rectangular die areas on a wafer, like in the heatmap below (not as poin...
belikin23HI JMP users, I have a column that contains data in the format DD-MM-YY H:M:S (screenshot attached below), and I would like to adjust only the hour values to make them even. For example, I w...
chandankishor66Hi All, I am trying pull some data from the database by looping through dates, in this example, I am trying to loop from June until the date yesterday. This is my sample code. However, it is not wor...
UserID16644Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. ...
SDF1Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the mom...
CamillaLiscioWhat determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on cre...
jthiI have difficult to get the filepath correct. Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus...erformance of code (https://community.jmp.com/t5/Discussions/Differentiate-between-entire-column-and-current-row/m-p/677701/highlight/true#M86401) - to bugfix my code - to find out more about the nuts and b...
hogi4 Day Course Monday, July 22| 9:00 a.m. - 12:30 p.m. ET Tuesday, July 23 | 9:00 a.m. - 12:30 p.m....
Learn the basics of using JMP without leaving your desk. Sign up for complimentary Web training, liv...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to interactively automate anal...
Register here: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-python-30jul2024.html &nb...