Return "True" or "False" if multiple columns contain string
Hi, I would like to return "False" if any column data contains "hello" else return a "True" I am only able to process 1 column with if, any ideas?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I would like to return "False" if any column data contains "hello" else return a "True" I am only able to process 1 column with if, any ideas?
Hello everybody, i would like to generate a plot which is showing the machine capacity (with a defined production time) of 5 different machines over a certain period of time (see the attatched imag...
Hi, I have created a Journal with multiple Distribution Histogram and Tables using scripts and saved as .html. When I email and share the html file with other people, the embedded graphs are n...
Hello, I have a large set of binary data (0, 1). I am using JMP Genomics ANOVA to compare the means between two groups. I was expecting a significant difference between Group 1 and HC for certain g...
Hello everyone, I would like to make a control chart without the LCL limit. Is it possible to remove it? Here is my script example: KSigma( 9.87903978847575 ), Chart Col( :"Y"n, P(...
Hello, I have a large set of binary data (0, 1). I am using JMP Genomics ANOVA to compare the means between two groups. I was expecting a significant difference between Group 1 and HC for certain gen...
Hi, I have a table with a "result" column and about 100 process variable columns. I want to know which process variable affect my result most. One simple way is to plot Each Process Variable ...
Hi All, I'm trying to run batch file automatically every day when radio button -"run whether user is logged on or not" is selected and it doesn't work. It works only when radio...
Hi, I'm using the choice model platform. I notice there are "estimate" and "standard error" in the "parameter estimate" report, but I'd also like to know the p-values for my parameter estimates...
Hi, I created a graph to show the number of claims received by date. For this case there is one claim received on the 24th June 2019. Why is the bar not indicating the right date but showing...
Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next ...
Hi, when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked: By selecting a row in the summary table the corresponding rows in...
Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine. I used 10 devices and measured these devices 5 time...
Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predicto...
Query Builder - date filter. SQL Server JMP version 16.2 In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the ...
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...