You can easily join together columns from different tables to form joined,
integrated tables. In many contexts, grids are joined 'behind the scenes' using common columns like participant or cohort identifiers.
Integrate Data from Different Tables
- Click the (Grid Views) icon and select Customize Grid.
- The left pane shows available columns, including columns from other datasets.
- Expand the node Participant ID and select Cohort. (This is a column from a different dataset: "Demographics".)
- Click View Grid.
- Notice that the columns are added to the Physical Exam table, creating a hybrid dataset.
Exclude and Visualize
- Click the Cohort column header and select Filter.
- Exclude one of the cohorts.
- To visualize, click CD4+ and select Quick Chart.
- Or choose another option from (Reports and Charts) -- many other visualization options are available.
===============================================================