Using JMP • Reshape Data

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

Previous
 • 
Next
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
Update Data Tables
Example of Updating a Data Table
Anonymize Data

Previous
 • 
Next
Help created on 3/19/2020