Error on Filter Condition on SQL Query
Hi, I am trying to get data from a Access DB via SQL Query. I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such va...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I am trying to get data from a Access DB via SQL Query. I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such va...
Hi All, I want to select certain rows that have string ended with "452" in column "Sample_ID" and make a subset containing these rows. I try to do like below but it didn't work ...
Bonjour, J'ai une table de donnée de très grande taille (environ 6 million de lignes). Elle a notamment comme colonnes une colonne Date, une colonne Référence Produit et une colonne Résultat (qui a ...
Can some help me with how to demarcate a plot of the field containing about 3500 data points into 24 different zones? Using Binning formula might be a great idea but I am not seeing any webinar on t...
Hello, I am adding two columns and it works. However, there are some cells that have a "dot" (not zero) on the two columns that make the formula not work. Is there away to change the dots ...
Hi, I am trying to get data from a Access DB via SQL Query. I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such va...
I have a datatable with 5 columns. Field names are from from A to Z. Now i want to seperate this table into 5 si gnetables. Every table just contain one column. The table A has one column A. Until th...
Hello, I have a master prediction formula that consists of 4 different prediction formulas. To develop prediction formulas I used Boosted trees and Boosted forest. So once I combined them toge...
Hello, In JSL, I want to use a specific cell value to create a column. how can I do it? From this: ID 1122 Name Age Johan 23 David 34 Jack 27 to Thi...
I have been trying to generate an interaction plot after GLM poission regression on JMP 14.0, but I can not do it there. I have an experimental data with three way interaction, and want to present th...
Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific gu...
Hello, In JMP 14, Multi File Import of a network folder was relatively fast. For example, it takes ~11 seconds to load the below folder. With JMP 16 on the same com...
Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connec...
Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, ...
Hi all, I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, whe...
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...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...