JMP User Community

Latest Discussions

How to determine blank columns

Hi all, How can I write an If Else statement when an existing column is blank, then it will create another column. If it is existing and not blank, then there is no need to create an additional column. Here's a snip of the code:dtcol = dt << get column names( "String" ); If( Contains( dtcol, "Name" ), /* but column is blank, create another column Name2 */ );
UserID16644

Discussions |
Jun 17, 2022 12:05 AM

2338 views | 5 replies
How to export JMP Data Tables as different Tabs of an Excel Sheet ?

Hi,I have a couple of JMP Data Tables open and would like to export these as different tabs of one excel sheet.How can I do this in JMP script?Thanks,
Aman
b55019

Discussions |
Jun 16, 2022 3:31 PM

18201 views | 17 replies
How to set variables from imported json file / jmp Associative Array?

Hi All, I am using Application Builder to develop a tool for data analytics with Python integration. I have created a button to export a user's parameter selections in case they want to re-upload those at a later time and perform the same data preprocessing. Currently, the way I export the parameters is I first script them to a csv (using Save Text File(...) ), then it can be opened as a jmp table...
EstelleS

Discussions |
Jun 16, 2022 10:15 AM

3708 views | 5 replies
Matching Spatially Inhomogeneous Data

I have two data tables of values that are spatially mapped, but the coordinates of one table are not the same coordinates as the second. I would like to "Join" these tables but have the data match by coordinate so I can compare the spatially variant values between the two tables. Does anyone know if there's an easy way to do this instead of just brute force calculating for every value? There looks...
Resonator_Drift

Discussions |
Jun 16, 2022 10:13 AM

1746 views | 5 replies
Wrap Text in HTML

Hi Community, The script below creates a journal with wrapped text. However, when I save this as an HTML file, the text is no longer wrapped. How can I maintain formatting from the journal to an HTML file? win= New Window("Metrics", <<journal, hlb = H List Box( Spacer Box(size(400,1000)), V List Box( Spacer Box(size(10,10)), cb = H Center Box(), Spacer Box() ), Spacer Box(si...
Awooley

Discussions |
Jun 16, 2022 10:12 AM

1384 views | 2 replies

Previous
Next

Latest Discussions

How to determine blank columns

Hi all, How can I write an If Else statement when an existing column is blank, then it will create another column. If it is existing and not blank, then there is no need to create an additional column. Here's a snip of the code:dtcol = dt << get column names( "String" ); If( Contains( dtcol, "Name" ), /* but column is blank, create another column Name2 */ );
UserID16644

Discussions |
Jun 17, 2022 12:05 AM

2338 views | 5 replies
Wrap Text in HTML

Hi Community, The script below creates a journal with wrapped text. However, when I save this as an HTML file, the text is no longer wrapped. How can I maintain formatting from the journal to an HTML file? win= New Window("Metrics", <<journal, hlb = H List Box( Spacer Box(size(400,1000)), V List Box( Spacer Box(size(10,10)), cb = H Center Box(), Spacer Box() ), Spacer Box(si...
Awooley

Discussions |
Jun 16, 2022 10:12 AM

1384 views | 2 replies
How to change order on a "compare means" chart

Hey everyone, Im trying to change the order on a Tukey-Kramer compare means chart and cannot figure out how.Our response variable is a swell property, where lower swell is desired. How do I get my charts to show the lowest values at the top and largest at the bottom (specifically for a connecting letters report)? I've tried hitting 'reverse' on the value order on the columns of said variable, to ...
CriticalDoe368

Discussions |
Jun 14, 2022 11:12 AM

965 views | 1 replies
X Bar & R chart Tool tip

How to see the serial number of each point on the chart when placing the mouse over it? I would like the chart to tell which data point each dot refers to. Thanks.
XN

Discussions |
Jun 14, 2022 7:25 AM

1525 views | 2 replies
Summary Table - Getting rows for each group combinations, including empty ones

Hello,I am writing on of my first scripts in JMP, and would like to get a nice chart of the proportion of events per months. I am using a summary table to get the sum of quantities of events per month, but there are some quiet months for which I do not have any data points.How could I get the empty months to till be displayed in my chart? For example in the two charts below, I would like the left ...
STA

Discussions |
Jun 14, 2022 7:11 AM

1777 views | 5 replies

Previous
Next

Latest Discussions

Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

799 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

640 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

804 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

1024 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

717 views | 0 replies