Install Add-In, then launch from main menu: Tables > Dynamic Subset
Purpose:
This Add-In creates a Dynamic Subset, which is a filterable view of your open data table so you can view only the rows and columns that meet the conditions you specify.
Video Example:
Instructions For Use:
- First download, then open the Add-In to install the new menu item "Dynamic Subset" to your Tables Menu.
- With a data table already open, select the menu item Tables > Dynamic Subset. A new window will open with a linked subset of your original table, including two outline boxes on the right, Columns Filter and Data Filter.
- The Columns Filter outline box allows you to select which columns you wish to see in your Dynamic Subset.
- The Data Filter outline box contains a JMP Data Filter where you can specify criteria your data must meet to be displayed in the Dynamic Subset.
- To use the Columns Filter, select the columns you wish to see in the Dynamic Subset. Hit Clear, or deselect all columns to show all available columns in the Dynamic Subset.
- To use the Data Filter, select a column or columns to filter based on and click the plus sign. Then, in the resulting selection areas pick what criteria your data must meet in order to be included in the Dynamic Subset. For more details on using the JMP Data filter, see this example video (Using the Local Data Filter ), or read about it in the JMP documentation.
- After making selections you can use JMP platforms as usual on your Dynamic Subset and only the rows and columns you have selected will be available and used for analysis.
- Save a view by selecting the Red Triangle next to Filters > Save View to Data Table. This will save a script to the data table with the necessary information to recreate your Dynamic Subset. You can apply this view from inside of an existing Dynamic Subset, or launch directly from your table if no Dynamic Subset is already open.
Usage Notes:
- If you first select columns in your original table table, then select Add-Ins > Dynamic Subset, the columns selected will be automatically added as filterable criteria in the Data Filter section.
- The Dynamic Subset is a linked subset of your original table, so the selections you make in the Dynamic Subset will select the corresponding rows in your original table.
- The Dynamic Subset is locked by default. To unlock, select the Red Triangle next to the table name, and uncheck "Lock Data Table."
Note that, as is the case with any linked subset in JMP, many changes you make in Dynamic Subset will not impact the original table, such as making new columns. Alterations to data in cells and column properties will impact your original table. Any adjustments you make to the columns or data filter will revert your table back to your original table.
- You can select Tables > Dynamic Subset with no table open and you will be prompted to pick a table. In this case, the original table is hidden from view by default, but can be shown by selecting the table under the menu item Window > Hidden.