A simple way to automate "File Import/Append/Cleaning/Generate Report"
Created:
Mar 2, 2020 09:16 AMLast Modified: Mar 20, 2020 9:20 AM
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:
Create a file dialog to allow you to select and open a file
Append that data to a "master data table"
Clean the data (using stored Recode command)
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%
0:00
Stream Type LIVE
Remaining Time -8:15
1x
Chapters
descriptions off, selected
captions settings, opens captions settings dialog
captions off, selected
en (Main), selected
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
End of dialog window.
This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.
// = = =
// 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
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."