Workflows are a no-code way to automate analyses and reports you use often or daily. In addition, you can convert the workflows to JSL scripts to offer a smooth user experience and more polished presentation. This demo shows the basics of how to understand and modify workflow scripts and make them more flexible for new data and new users. It assumes you have some background in creating a JMP Workflow.
The case study uses three sources that we use to build the workflow using data from the years 2015-2017 and then make a script that can work with data from subsequent years.
The attached .zip file includes all the files you need to practice, including, two versions of the childcare Excel data and the Childcare Analysis JMP Add-In.
See how to:
- Understand some of the JSL basic components
- Comments
- Referring to columns in data tables
- Expressions and objects to which they refer
- Path variables
- Create Workflow
- Save out the workflow script
- Edit the script to generalize for new data and new users
- Change table names and file paths
- Create data table name variables
- Add user input mechanisms as needed (Pick File, Column Dialog, etc.)
- Choose a file
- Create JSL to pick a file based on specific criteria
- Default to current open data table
- Choose a column and then unload the selected column from the dialog, to act on it later in the script.
- Use embedded report Column Switcher rather than choose a column
- Optionally save the script as a JMP add-in for distribution
- Create the Add-in using File > New > Add-in
- Create a menu item and/or a toolbar item to launch the script
- Include data files, PDFs, etc.
- Install the add-in and share with other users that can install by double-clicking on the *.jmpaddin file
- Analysis JMP Add-In.
