JMP 14.0 Online Documentation (English)
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Predictive and Specialized Modeling
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP iPad Help
JMP Interactive HTML
Capabilities Index
JMP 13 Online Documentation
JMP 12 Online Documentation
Using JMP • Reshape Data
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 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
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
Update Data Tables
Example of Updating a Data Table
Anonymize Data
Previous
•
Next
Help created on 7/12/2018