This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Choose Language Hide Translation Bar
Excel and Automation
Created: May 16, 2022 02:51 PM  |  Last Modified: May 16, 2022 04: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