Subset by
|
To subset by the levels of a column, select Subset by and select the columns that you want to categorize for the subset.
Consider the fact that many new data tables might be created. A new data table appears for each level of the column that you specified in the Subset window.
|
All Rows
|
Creates a subset table that contains all rows from the active table.
|
Selected Rows
|
Creates a subset table that contains only the selected rows from the active table.
|
Random - sampling rate
|
Creates a subset table whose data is a random proportion of the active data table. Enter the proportion of the sample that you want in the text box. For example, if you want a random 50% of the data to be included in the new table, enter 0.5 in the text box.
|
Random - sample size
|
Creates a subset table whose data is a random sample of the active data table. Enter the size of the sample that you want in the text box. For example, if you want 16 random rows to be included in the new table, enter 16 into the text box.
If you select a random sample that is the entire source table, the result is a random shuffle of the rows of the data table. If you specify columns to stratify, the result is a random shuffle of each of the rows for each group. See “Stratified Subsets”.
|
All columns
|
Creates a subset table that contains all columns from the active table.
|
Selected columns
|
Creates a subset table that contains only the selected columns from the active table.
|
Keep by columns
|
Retains the column that you subsetted by in the output data tables.
|
Output table name
|
To give a name to the subset table, type a name in the box beside Output table name.
|
Link to original data table
|
To keep the subset table linked to the original table, click the box beside Link to original data table. When you change values in one table, the other table is updated.
|
Copy formula
|
To include formulas from the original table in the output columns, click the box beside Copy formula. Include all columns needed for the calculation of the formula.
|
Suppress formula evaluation
|
To prevent JMP from evaluating columns’ formulas when the new table is created, click the box beside Suppress formula evaluation.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
Select Columns Filter Menu
|
Contains options to search and filter through columns. See “Columns Filter Menu” in the “JMP Platforms” chapter.
|
Replace Table
|
To replace the original data table with the sorted table instead of creating a new table with the sorted values, click the box beside Replace Table. This option is not available if there are any open report windows generated from the original table.
|
Output table name
|
(Optional) To give a name to the sorted table, type a name in the box beside Output table name.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
By
|
Adds the columns that you want to sort by. The columns that you add to the list establish the order of precedence for sorting. The first column in the list is the major sort field. Each variable thereafter is sorted within the previous variable in the sort list.
|
Remove
|
Removes any highlighted columns.
|
ascending and descending buttons ()
|
To change the list order (ascending or descending) of the values for the grouping variables, in the By variable list, select a variable and click the appropriate ascending or descending button. The icon beside the variable changes to indicate the sorting order.
|
Select Columns Filter Menu
|
Contains options to search and filter through columns. See “Columns Filter Menu” in the “JMP Platforms” chapter.
|
Multiple series stack
|
To stack selected columns into two or more columns, check the box beside Multiple series stack. Specify the number of columns into which you want the selected columns to be stacked by entering the number into the Number of Series box. This box appears when you check the box beside Multiple series stack.
Select the Contiguous option if the series consists of adjacent columns.
Note: The order in which you add columns to the box on the right determines the group to which they belong.
|
Stack by Row
|
Leaving Stack by Row unchecked stacks one column underneath another. Checking it stacks columns by rows.
|
Eliminate missing rows
|
To eliminate missing data from the new table, check the box beside Eliminate missing rows. If Stack by Rows is checked also, only rows with all data missing are eliminated.
|
Non-stacked columns
|
Includes or drops non-stacked columns from the new data table. Select one of these options:
Keep All
select this option if you want the new table to contain all of the non-stacked columns from the original table.
Drop All
select this option if you want to include only the stacked columns in the new table, and you do not want to include any non-stacked columns.
Select
Choose the non-stacked columns that you want to include or drop in the new table.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
Stack Columns
|
Adds the columns that you want to stack.
|
Remove
|
Removes any highlighted columns.
|
Output table name
|
(Optional) To name the new table, type a name in the box beside Output table name.
|
Stacked Data Column
|
To assign a name to the column that will contain the data for the stacked columns, enter a name in the Stacked Data Column box. Leave the box empty if you do not want this column to appear in the new table.
|
Source Label Column
|
To assign a name to the column that will contain the original table’s column names, enter the name in the Source Label Column box. The default name is Label. Leave the box empty if you do not want this column to appear in the new table.
|
Copy formula
|
To include formulas from the original table in the output columns, click the box beside Copy formula.
|
Suppress formula evaluation
|
To prevent JMP from evaluating columns’ formulas when the new table is created, check the box beside Suppress formula evaluation.
|
Select Columns Filter Menu
|
Contains options to search and filter through columns. See “Columns Filter Menu” in the “JMP Platforms” chapter.
|
Keep All
|
To include all columns in the new table, click the Keep All option in the Remaining Columns area.
|
Drop All
|
To include only columns used in the split in the new table, click the Drop All option in the Remaining Columns area.
|
Select
|
To select which columns to keep in the new table, click the Select option in the Remaining Columns area. Then select which columns to keep in the new table.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
Split By
|
Adds the column whose values you want to use as the new column names, and as the basis for splitting the column.
|
Split Columns
|
Adds the column or columns that you want to split.
|
Group
|
Specify a Group variable when you want your data to be split within each group of the selected variable. Each group results in a row in the output table.
Note: You must also specify the required variables, Split By, and Split Columns.
If your grouping variable contains unequal groups, or if your grouping variable is not grouped in order (is random), then you must specify a Group variable. The Group variable ensures that your data is restructured properly.
|
Sort by Value Order
|
Sorts the order of the output columns by a Value Ordering property. Before using this option, you must have a Value Ordering property assigned to the column that you want to split by.
|
Output table name
|
(Optional) To assign a name to the new table, enter the name in the box beside Output table name.
|
Copy formula
|
(Only appears if there is a formula in the data table) To include formulas from the original table in the output columns, click the box beside Copy formula.
|
Suppress formula evaluation
|
(Only appears if there is a formula in the data table) To prevent JMP from evaluating columns’ formulas when the new table is created, click the box beside Suppress formula evaluation.
|
Select Columns Filter Menu
|
Contains options to search and filter through columns. See “Columns Filter Menu” in the “JMP Platforms” chapter.
|
Transpose selected rows only
|
To transpose only rows that are currently highlighted in the active table, click the box beside Transpose selected rows only.
|
Output table name
|
(Optional) To name the subset table, type a name in the box beside Output table name.
|
Label column name
|
(Applicable only if you have specified a Label column.) Specify an alternative name for the Label column. Otherwise, the default column name is Label.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
Transpose Columns
|
Adds the columns that you want to transpose.
|
Label
|
To use the data from a column in the original table as the column names in the new table:
1. Highlight a column from the Select Columns box on the left.
2. Click Label. The column name appears in the Label box.
The default column name is name. You can specify an alternative name for the column using the Label column name option. Only one column is created for each distinct value in the label column. Therefore, if there are duplicate values in the label column, JMP creates only one column for the duplicated value using the value from the last duplicated row.
|
By
|
To organize the transposed columns into groups based on the columns that you put into the By box:
1. Highlight the column name(s) in the Select Columns box whose values you want to see as a group.
2. Click By.
|
If
|
Then
|
The original table has columns but no rows
|
The new table contains one column that lists those column names.
|
The original table has one column and it is assigned to Label
|
Its values become the column names in the transposed table.
|
The original table has multiple columns and contains a label column
|
JMP automatically inserts the label column into the Label box when the window appears. You can remove this column if you do not want it to appear.
|
There is no label column in the original table
|
The column names in the transposed table are Row 1, Row 2, …, Row n where n is the number of rows in the original table.
|
Keep dialog open
|
To keep this window open after clicking OK, check the box beside Keep dialog open.
|
Preserve main table order
|
Maintains the order of the original data table in the joined table, instead of sorting by the matching columns.
|
Update main table with data from second table
|
When Update main table with data from second table is checked, column data from the second table change the data of the same name columns in the original table.
Note the following:
• JMP does not replace data with missing values.
• The output table uses the same columns as the original table. Thus, when you use Update main table with data from second table, Select Columns for joined table is not applicable.
• The Update main table with data from second table option is available only when joining by row number or by matching columns.
|
Merge same name columns
|
Click the box beside Merge same name columns if you want the data from the second table to replace the data of the same name columns in the original table. Note that missing values in the first table are replaced by nonmissing values in the second.
If you join by matching columns, the new table contains a nominal column named Match Flag:
• If a one (1) appears in this column, the data originated from the first (active) table.
• If a two (2) appears in this column, the data originated from the second table.
• If a three (3) appears in this column, the data was found in both the first and second tables.
|
Copy formula (Main Table and Second Table)
|
Click the box beside Copy formula to include formulas from the main table and/or the second table in the output columns.
|
Suppress formula evaluation (Main Table and Second Table)
|
To prevent JMP from evaluating columns’ formulas during the creation of the new table, click the box beside Suppress formula evaluation for the main table and/or the second table.
|
By Matching Columns
|
To join rows, select columns in both tables whose values and data types match. You should:
1. Highlight a column name from each list in the Source Columns area. The first highlighted column in the top list pairs with the first highlighted column in the bottom list, the second columns are paired, and so on. Rows join only if values and data types match for all the column pairs.
2. Click Match. The selected pair of columns appears in the Match columns box. Matching columns do not have to have the same names and do not have to be in the same relative column position in both tables.
3. (Optional) To only include the first match found, check the boxes associated with Drop multiples in both tables. Only the first match found is written to the new table. If you specify this option for one table, the first match value is joined with all matches in the other table. If you do not check the boxes associated with Drop multiples in either table, a Cartesian join is performed within each group of matching column values.
4. (Optional) To include all rows from the data table, even when there is no matching value, check the boxes associated with Include non-matches. You can specify this option for either or both data tables being joined.
|
By Row Number
|
Joins the two tables side by side.
|
Cartesian Join
|
Joins two tables using a Cartesian fashion, where it forms a new table consisting of all possible combinations of the rows from two original tables. JMP crosses the data in the first table with the data in the second to display all combinations of the values in each set.
|
Select Columns for joined table
|
Select the Select Columns for joined table option if you want to select a subset of columns from either table for inclusion in the output table. Follow these steps:
1. In the Source Columns area, highlight the columns from each table that you want to include in the new table.
2. Click Select in the Output Columns area.
|
Output table name
|
To give a name to the joined table, type a name in the box beside Output table name.
|