cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

JerryFish
Staff
A simple way to automate "File Import/Append/Cleaning/Generate Report"

Ever wanted to automate processes and analyses? You can do it in JMP! This video shows how to automate the following steps, with a minimal amount of JSL (JMP Scripting Language) coding:

  1. Create a file dialog to allow you to select and open a file
  2. Append that data to a "master data table"
  3. Clean the data (using stored Recode command)
  4. Generate a report from the updated Master Data Table

Simple Automation Script.mp4 (2)
Video Player is loading.
Current Time 0:00
Duration 8:15
Loaded: 2.02%
Stream Type LIVE
Remaining Time 8:15
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
    • en (Main), selected
    (view in My Videos)

    Comments
    jntwist
    Level II

    Good video.  Thanks.  JT

    Sebnem
    Level II

    Hello,

     

    Can you make the script available?

    rc_hertzy
    Level III

     

    // = = = 
    
    // Script to concatenate a file to an existing master file
    Names Default To Here( 1 );
    // Open the master data table
    // Then call current master data table "dtmaster"
    dtmaster = Current Data Table();
    // Open file dialog to select file to be appended to master, name it "dtnew"
    // If an Excel file the Excel Import wizard will open
    dtnew = Open();
    
    //Concatenate the new to the master file by appending it
    dtmaster << Concatenate( dtnew, Append to first table );
    
    //Close new table
    Close( dtnew, NoSave );
    // Now the master file contains the new appended info
     
    Bass_Masri
    Level VI

    Brilliant Jerry - Great tips for automation.

    PatrickGiuliano
    Staff

    Thanks @JerryFish for preparing and posting this!  A nice bite sized guided video journey into automating a script with importing.

     

    I'd like to share another nice reference here on data preparation and analysis in JMP since I think it is at least partially connected to what you have shared; It's a white paper available on jmp.com entitled: "JMP takes the struggle out of data wrangling." 

     

    Cheers,