Reshape Your 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 6.1 Creating a Subset Data Table from a Report 

Contents

Create a Subset Data Table

Create a Subset Data Table from a JMP Report

Sort Data Tables

Stack Columns in Data Tables

Example of Stacking Columns into a Single Column

Example of Stacking Columns into More Than One Column

Split Columns in Data Tables

Examples of Splitting Columns

Transpose Rows and Columns in a Data Table

Examples of Transposing Rows and Columns in a Data Table

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

Example of a Link ID and a Link Reference on a Single Column

Update Data Tables

Example of Updating a JMP Data Table

Anonymize Data

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).