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

[#1]

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.

Play Video

Play

Mute

Current Time 0:00

/

Duration 8:15

Loaded: 0%

0:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -8:15

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

• en (Main), selected

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

[jntwist]

Good video.  Thanks.  JT

[Sebnem]

Hello,

Can you make the script available?

[rc_hertzy]

// = = = 

// 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]

Brilliant Jerry - Great tips for automation.

[PatrickGiuliano]

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,

[PatrickGiuliano]

https://www.jmp.com/en_gb/whitepapers/jmp/jmp-takes-the-struggle-out-of-data-wrangling.html