cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Excel and Automation
Created: May 16, 2022 02:51 PM  |  Last Modified: May 16, 2022 1:08 PM

See how JMP automatically captures actions as JMP scripts (JSL) and how you can easily edit these interactively to automate analyses.

 

Laura_Higgins_0-1652731281929.png

 

Example: Workflow Automation (Also avaiable as separate video.)

  • After we use the Excel Import Wizard to import data, we can use the associated script that JMP provides for the sequence of steps we followed during and after import.
  • In JMP 16 and later, use the Enhanced Log (Action Recorder) to capture all import steps, data preparation steps, and final reports.  In this case those are Import, Stack, create a Graph created using Graph Builder.
    • Save Script to Script Window from the Enhanced Log and Hit the Run/Play icon on the Menu Bar.
  • In versions earlier than JMP 16, you can combine the Import, Stack, Graph Builder, and scripts manually.

 There is another video with several examples of importing Excel data - Importing, Consolidating and Maximizing the Value of Excel Data 

 

(view in My Videos)

 

 

This is part of the Get Going with JMP series.

0 Kudos

Recommended Articles