Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
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

3 Comments
Level I

Good video.  Thanks.  JT

Level II

Hello,

 

Can you make the script available?

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