Reshape Data

JMP Support 800.450.0135 (US)

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

Using JMP • Reshape Data

•

Create Subsets, Sort Data, and More

This chapter covers the following tasks that you can perform on JMP data:

•

create a new data table from a subset of rows and columns

•

sort by any number of columns

•

stack multiple columns into a single column

•

split a column into two or more columns

•

transpose rows and columns

•

concatenate multiple tables end to end

•

join two tables side by side

•

virtually join tables without physically joining them

•

update columns in a table with values from another table

•

anonymize the data

Figure 5.1 Creating a Subset Data Table from a Report

Contents

Create a Subset Data Table

Stratified Subsets

Create a Subset Data Table from a Report

Sort Data Tables

Example of Stacking into One Column

Example of Stacking into More Than One Column

Examples of Splitting Columns

Transpose Rows and Columns

Examples of Transposing Rows and Columns

Concatenate Data Tables

Example of Concatenating Data Tables

Example of Concatenating Data Tables and Table Variables

Join Data Tables

Examples of Joining Data Tables

Query and Join Data Tables with JMP Query Builder

About Links to Data Tables in JMP Queries

Virtually Join Data Tables

Example of Virtually Joining Columns

Example of Virtually Joining Columns and Showing Row States

Example of Merging Referenced Data in Virtually Joined Data Tables

Update Data Tables

Example of Updating a Data Table

•

Help created on 10/11/2018