cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Guillermo
Level I

Batch Processing

I have multiple folders (4), each folder with multiple files (4), each file with multiple sheets (12), each sheet with a matrix of about 80x20. Speaker sound pressure level vs frequency.

 

I am looking to extract the data in JMP, put it back on the same folder for each file, for each sheet, and run a simple x by y correlation matrix, where x=the first 10 files and y=the second 10 files, files BUT PICK off and report ONLY the results from the diagonal files.   

 

I can do this in MATLAB ALL DAY LONG, but need an easy way to script this in JMP.  

 

 

 

 

2 REPLIES 2

Re: Batch Processing

I don't understand the problem. You already have a solution with MATLAB.

 

You should read the scripting guide to learn how to code in JMP. The JMP scripting language is not the same as any other computer language. It does provide extensive matrix processing but it is not the same as MATLAB.

 

You can use your MATLAB solution in JMP. The scripting guide describes the functions to perform the necessary actions for JMP and MATLAB to work together.

 

You want to calculate Pearson's linear correlation coefficient for two sets of ten spectra or curves?

Byron_JMP
Staff

Re: Batch Processing

Not sure I understand why you want to preserve your folder structure. Is there some reason you can't combine the data in to one flat file, or maybe 4 virtually joined tables?

 

JMP Systems Engineer, Health and Life Sciences (Pharma)