Split Columns

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Reshape Data • Split Columns

•

You can create a new data table from the active table by splitting one column into several new columns. This column is split according to the values found in another column, referred to as the Split By column. You can also split columns according to the values of one or more grouping variables.

Note: If the split is on a categorical column that contains a missing value, the column name for the missing category is “.” for a numeric column.

To split columns, follow these steps:

1.

Select Tables > Split.

Figure 5.12 Split Window

2.

Highlight the names of the column or columns that you want to split and click Split Columns.

3.

Highlight a column whose values you want to use as the basis for splitting the column.

4.

Click Split By.

5.

Customize your splitting further using the additional options.

6.

Click Split.

Select Columns Filter Menu

Contains options to search and filter through columns. See Column Filter Menu in Get Started.

Includes all columns in the new table.

Includes only columns used in the split in the new table. Selected by default.

Selects which columns to keep in the new table.

Keep dialog open

Keeps the Split window open after you click OK.

Adds the column whose values you want to use as the new column names, and as the basis for splitting the column.

Adds the column or columns that you want to split.

Specifies 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. You must also specify the required variables, Split By, and Split Columns.

Note: If the variable that you want to group by contains unequal groups or is in a random order, specifying it as the Group variable ensures that your data is restructured properly, and any missing values are assigned in the appropriate places.

Sort by Column Property

(Appears if a Value Ordering or Row Order Levels property is found) Sorts the order of the output columns by the Value Ordering or Row Order Levels column property. Value Ordering takes precedence over Row Order Levels.

If the column has neither property, and the data has an implied order (such as days or months), the implied order is applied.

Output table name

(Optional) Specifies the name of the new table.

(Appears if there is a formula in the data table) Includes formulas from the original table in the output columns.

Suppress formula evaluation

(Appears if there is a formula in the data table) Prevents JMP from evaluating columns’ formulas when the new table is created.

•

Help created on 10/11/2018