JMP User Community

Latest Discussions

Working on multiple data files and creating a summary table that contains the mean, std, etc.

Hi, Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation, cpk, Spec limits, etc. I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...
RA899

Discussions |
Feb 21, 2024 10:07 AM

1636 views | 3 replies
Excel cell format

Hello

I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in ...
SeasonalControl

Discussions |
Feb 21, 2024 7:34 AM

1443 views | 2 replies
Importing of csv data

I am working on a large DoE where in total we need to measure more than 10.000 pieces, the measurement is done in a Renishaw CMM, and the way the program is made it has to calibrate every 50 pieces, and then it outputs a file for each characteristic which leads to alot of files having to imported, and today I am using the import function and then copy pasting the results into my master data sheet....
Oseali

Discussions |
Feb 21, 2024 7:07 AM

1356 views | 2 replies
dashboard

Bonjour, Juste une question pour les tableaux de bord sur JMP.
Comment peut-on créer plusieurs onglets comme ci-dessous sur le même tableau de bord ? Merci pour votre réponse !
hcarr01

Discussions |
Feb 20, 2024 11:24 PM

1868 views | 4 replies
Script for saving inverse prediction from fit curve into data table column

I am trying to write a script that does the same thing as fit curve>save formula>save inverse prediction formula; where the predicted values are automatically calculated and placed in a new column. I've tried a few different scripts I've seen suggested under other users questions but they haven't worked for me. The fit curve runs fine, but the values aren't input into a column.Am I missing a line ...
Mcc99

Discussions |
Feb 20, 2024 10:05 AM

1491 views | 2 replies

Previous
Next

Latest Discussions

Working on multiple data files and creating a summary table that contains the mean, std, etc.

Hi, Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation, cpk, Spec limits, etc. I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...
RA899

Discussions |
Feb 21, 2024 10:07 AM

1636 views | 3 replies
Excel cell format

Hello

I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in ...
SeasonalControl

Discussions |
Feb 21, 2024 7:34 AM

1443 views | 2 replies
Importing of csv data

I am working on a large DoE where in total we need to measure more than 10.000 pieces, the measurement is done in a Renishaw CMM, and the way the program is made it has to calibrate every 50 pieces, and then it outputs a file for each characteristic which leads to alot of files having to imported, and today I am using the import function and then copy pasting the results into my master data sheet....
Oseali

Discussions |
Feb 21, 2024 7:07 AM

1356 views | 2 replies
dashboard

Bonjour, Juste une question pour les tableaux de bord sur JMP.
Comment peut-on créer plusieurs onglets comme ci-dessous sur le même tableau de bord ? Merci pour votre réponse !
hcarr01

Discussions |
Feb 20, 2024 11:24 PM

1868 views | 4 replies
Analysis of comment field

Hi all,I have been provided with a report tracker, in which users in my organisation have provided different types of comments. Unfortunately, this all appears in one column per report (row). For most comments, it comes with a date (in a variety of different formats). I´m trying to get a reasonable overview of what happened when (e.g. create a new column per date), but cannot really find a good ap...
JulieSAppel

Discussions |
Feb 20, 2024 2:00 AM

1358 views | 2 replies

Previous
Next

Latest Discussions

Scheduled job failed

Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
shaiv90

Discussions |
Feb 11, 2024 11:09 PM

830 views | 0 replies
PickFile(), Projects and Network Drives

Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
hogi

Discussions |
Feb 9, 2024 3:07 PM

886 views | 0 replies
How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...
mann

Discussions |
Jan 31, 2024 6:25 AM

1092 views | 0 replies
GraphBuilder Legend hook

There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph. With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message. The same cannot be done (to my knowledge) with Gra...
ErraticAttack

Discussions |
Jan 17, 2024 6:41 PM

747 views | 0 replies
Copy Columns - selected rows

Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table. There is a hidden feature:
When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column. So, when you select all rows before...
hogi

Discussions |
Jan 3, 2024 1:27 PM

1226 views | 0 replies