Chapter 8: Joining, Subsetting, and Filtering

Introduction

Combining Data from Multiple Tables with Join

Saving Memory with a Virtual Join

Why and How to Select a Subset

A Brief Detour: Creating a New Column from an Existing Column

Row Filters: Global and Local

Global Filter

Local Filter

A More Durable Subset

Combining Rows with Concatenate

Query Builder for Tables

Back to the Movies

Olympic Medals and Development Indicators

Conclusion

References

Introduction

In Chapter 5, we noted the likelihood that any particular project might require only some of the data stored in a particular table or it might require data from different tables. In that chapter, we saw how JMP can facilitate database operations as part of extracting and importing data into ...

Get Preparing Data for Analysis with JMP now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.