Welcome to the JMP User Community!

Latest Discussions

• group file name and set lable by JSL looping, work fine but slowly

  I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...

  BayesRabbit7133

  Discussions |

  Feb 22, 2024 12:24 AM

  734 views | 0 replies

• 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

  1390 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

  1248 views | 2 replies

• How to add JSL to "Big Class.jmp" graphics using Hover Labels?

  Start with the following JSL to generate the graph.
  How to add JSL through Hover Labels to get cell name data Get "Big Class Families" file corresponding name data?dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );

  lala

  Discussions |

  Feb 21, 2024 7:09 AM

  2221 views | 8 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

  1108 views | 2 replies