Writing to an SQL database
The SQL connection in JMP is great for reading data - is anyone using it to write data? I have a stored procedure which gathers data and writes it to a new table. It uses a second table to read th...
![](https://community.jmp.com/legacyfs/online/a69584_cauliflowerleaf_sm.png)
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesThe SQL connection in JMP is great for reading data - is anyone using it to write data? I have a stored procedure which gathers data and writes it to a new table. It uses a second table to read th...
Hi, I have a column with values of the following format: '20230818103947300000' I was hoping to be able to convert it using the custom format (i.e. <YYYY><MM><dd> etc), but I do no...
...60. Question 1: When I click on "make table" before adding data to the columns, I get the following output. I have some idea what the column Pattern means but I don't know if I should keep i...
Hello, I have an add-in that performs hide and exclude in a for loop. One thing I observed was that the previous hide and exclude gets overwritten by the next column condition. Additionally,...
Hi All, I'm updating a script that I've been working on that after the analysis is done, I want to save a picture of the report window and then save a script to the data table that wi...
Hi, I have a column with values of the following format: '20230818103947300000' I was hoping to be able to convert it using the custom format (i.e. <YYYY><MM><dd> etc), but I do no...
Hi everyone, I'm quite new to JMP Pro and the questions I'm about to ask are pretty basic. I have two independent variables and a dependent variable (response), all three meas...
Hello, I have an add-in that performs hide and exclude in a for loop. One thing I observed was that the previous hide and exclude gets overwritten by the next column condition. Additionally,...
I have a data set of 768 rows of data taken over 32 months from plots with different ground vegetation and plant genotypes. Climate data (T, RH, and Rain) were collected during the same period from a...
Hello. I am new here. I have a 2^3 full factorial screening DOE with 3 centre-points. I am fitting a second-degree interactions model, so there are 4 df left for the Total Error; 2 for lack of fit, 2...
Hello! I need to show that compositions of chemical mixture before and after treatment are significantly different. Composition is given in weight %, so the total of all components' weight % in the m...
I want to apply deep learning models in JMP pro, but unfortunately I can't fine any option in JMP pro, Please guide me how I can apply it into JMP pro (if it is available), if not, is there any add i...
Dear community, I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements). In the robust fit outlier platform I can detect outliers and than can s...
I read the previous posts on the two-way repeat measures ANOVA - Multivariate or univariate analysis, and the full factorial mixed model add-in. Now I have two questions: 1) When the data are ...
Points plot in Graph builder provides an option to calculate summary statistics. By default, points with same x value are aggregated into one value. Is there an option to select another col...
Topic: Building Robust and Fail-Safe Scripts Registration page: https://www.jmp.com/en_gb/...
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...