Combine Columns

JMP Support 800.450.0135 (US)

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

Using JMP • Enter and Edit Data • Restructure Data • Combine Columns

•

The Combine Columns option is the opposite of Text to Columns. Instead of making multiple columns, you can combine a set of columns into one character column with delimited fields.

To combine indicator columns, follow these steps:

Select Help > Sample Data Library and open Consumer Preferences.jmp.

Select the columns, Floss After Waking Up, Floss After Meal, and Floss Before Sleep.

Select Cols > Utilities > Combine Columns.

Type “Combined Floss” for the column name, and keep the default delimiter as a comma.

Select Selected Columns are Indicator Columns and click OK.

Figure 3.33 Combined Floss Column

The selected columns are represented in the Combined Floss column with each field separated by a comma. Only the columns that have a value of 1 are represented in the combined column for each given row.

Note: Value labels show a label in the data table instead of a value. A label appears for each instance of the value in the combined column. You can show the original values by double-clicking a label within a cell. To avoid using value labels, select No Value Labels when you combine the columns.

•

Help created on 7/12/2018