Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest Discussions
-
JSL get values from a table and make into a text string that can be used as an input in another datebase query
In my script I have multiple data base queries. From one query it get a column with a list of lot numbers. I want to take the values from this column and make them into a local variable that I can use in the next data query to pull data from a different database. using a script line below I get the value string.cassette = SLC:DESTINATION_CASS << get values; result cassette = {"SPQ093146 1"}How ...
chris_dennis
14477 views | 2 replies -
Set Column Values
I am creating several data tables, where I will add a Character column with repeating values. I am using the repeat function to do this. My trouble is that it seems to take a very long time for large repeat values. Is there a more efficient way to do this? I am using JMP11. Thanks!// Example.Names Default To Here( 1 );t1 = Tick Seconds();dt = New Table( "50000 Rows", Add Rows( 50000 ), N...
robot
14842 views | 2 replies -
formula for "text to columns"
Hi,I have a column with comma seperated values and by using column utilities text to column I get the column for each comma seperated value, however the dataset is growing hourl and by joining/concatenating the new data with the existing one I have to redo all the process again and again. Isn't there a formula for this (or better script)?Many thanks in advance
saitcopuroglu
10731 views | 4 replies -
How can I calculate by Functions?
Dear Community, I need your help to calculate as a new column as MinADR of:(600+500)-(400+300) / (60+50)-(40+30) placed in the row of Label "b"
saitcopuroglu
7203 views | 7 replies -
Newbie question: How can I select multiple rows with different values in one column?
this is my data table:A B9 130010 130011 130012 50013 90014 130015 130016 1300And I have three variables: M=10, N=11, and P=13 I want to select rows where A=M and A=N, and A=P.I wrote this line, but it only selects A=M.dt << Select Where (A==M& A==N & A==P) ;do you have any suggestions?
razmah
9494 views | 2 replies
Latest Discussions
-
How can I calculate by Functions?
Dear Community, I need your help to calculate as a new column as MinADR of:(600+500)-(400+300) / (60+50)-(40+30) placed in the row of Label "b"
saitcopuroglu
7203 views | 7 replies -
can row names be part of data
I am trying to run multivariate analysis involving peaks (chemical compounds) and treatments. is there a way to make the row number significant and usable as part of the data?
akennedy0
4828 views | 1 replies -
How to resample / interpolate unevenly spaced time series?
I have an dataset consisting of two columns, X and Y, resulting from a measurement (cyclic voltammetry using PAR potentiostat). Unfortunately, the spacing of X is not equal (varies between 0.0005 and 0.0015), and the instrument's software cannot fix this. I would like to resample or interpolate the data to get equal spacing of, say, 0.001 in X. Is there a fast way to do it?
michal_krompiec
11967 views | 2 replies -
How do I create contour plots with no legend via scripting?
I just want to prevent the legends from being generated, & I didn't see a way to do this in any help pages. I am generating lots and lots of contour plots and the legends take up too much room.Thanks!
rpeard
6793 views | 3 replies -
Incorporating Reference Lines into legend for multiple bivariate graphs.
Hello everyone!I would like assistance in order to incorporate reference lines at certain numbers of the Y axis, horizontal lines, directly into the legend.This is my current script
Bivariate(
Y( :Cat),
X( :Dog),
Histogram Borders( 1 ),
Where(:Recipe == "B_XX" & (:Tool == "A_XX")),
Elements( Points( X, Legend( 1 ) ) ),
SendToReport(Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 140, Solid, "...
saswatmishra50
3026 views | 0 replies
Latest Discussions
-
Incorporating Reference Lines into legend for multiple bivariate graphs.
Hello everyone!I would like assistance in order to incorporate reference lines at certain numbers of the Y axis, horizontal lines, directly into the legend.This is my current script
Bivariate(
Y( :Cat),
X( :Dog),
Histogram Borders( 1 ),
Where(:Recipe == "B_XX" & (:Tool == "A_XX")),
Elements( Points( X, Legend( 1 ) ) ),
SendToReport(Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 140, Solid, "...
saswatmishra50
3026 views | 0 replies -
Fit Y by X plot discrepancy (Oneway vs Bivariate)
Hi, I see a discrepancy in the plotted Y variables when plotting similar columns in the Oneway vs Bivariate plots. Bivariate plots the Y values correctly (left side below). Oneway seems to jitter the points on the Y-axis, which seems strange to me. I realize that my horizontal axis here is a numeric, and that bivariate makes more sense* but I'm just looking for a simple x-y scatter and I like the ...
mikedriscoll
4023 views | 0 replies -
how to invisible local data filter
Hi all,Till now I was using "Panel Box" and "Close" local data filter command for the invisible but functioning local data filter. Something like below closes the data filter it is visible by jmp graph but invisible by the HTML5 output (magical).nw[Panel Box( 1 )][Outline Box( "Local Data Filter" )] << Close( 1 );nw[Panel Box( 2 )][Outline Box( "Local Data Filter" )] << Close( 1 );
This time I use ...
saitcopuroglu
2734 views | 0 replies -
Fit Y by X Interactive HTML5 output
I don't know if anybody using the Interactive HTML output as intensive as me but Fit Y by X platform needs an upgrade about converting the jmp language to HTML5 language. Here is an example comparing the outputs of both. Almost none of the axis and font and colour settings seem to be carried over.
saitcopuroglu
2396 views | 0 replies -
PowerPoint Export of Journal
Is there a way to control the formatting of the exported PowerPoint deck? The exported file needs so much clean up I am not sure if it saves any time over cutting and pasting. I made a simple journal from the big class data table and a 1 page journal turns into a 5 page PowerPoint. The resulting PowerPoint is attached.
Hegedus
10151 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
12:00PM - 1:00PM EDTApr 3Teaching Predictive Modeling
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-predictive-modeling-...
-
2:00PM - 3:00PM EDTApr 3Virtual JMP Pharma and Biotech Club: "Comparability: One of These Things Is Not Like the Other"
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/jmp-pharmabio-club-03apr25.html &...
-
1:00PM - 2:00PM EDTApr 4Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
2:00PM - 3:00PM EDTApr 4Centralizing Shared JMP Reports Across or Within Groups Using JMP Live - Mastering JMP
Do you need to share reports with different work groups, suppliers or partners? Are you part o...
