For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Reshape Data
Publication date: 04/30/2021

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 6.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

Stack Columns

Example of Stacking into One Column
Example of Stacking into More Than One Column

Split Columns

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
Example of a Link ID and a Link Reference on a Single Column

Update Data Tables

Example of Updating a Data Table

Anonymize Data

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