How to Set Up and Manage Data File Relationships

Introduction

When an analysis is conducted using variables in multiple data files, Q needs to work out how the observations in the data files relate to each other. That is, a rule is needed by which to merge the data files. In order to create a relationship between two files. 

Requirements

• Two different data files loaded in Q. 
• There must be a variable in each file that contains the same type of data (text, categorical, dates, etc.) and has some values that match.

Method

Data file relationships can be edited by selecting File > Data Sets > Edit Relationships.

This window shows a list of any existing data file relationships. In order to crosstab questions from two different data files, those two data files must have a relationship that appears in this list.

To see more detail about an existing relationship, select it in the list, and then click Edit to view the Data Set Relationship details:

You can also remove an existing relationship by selecting it from the list, and then clicking Delete. 

To create a new relationship, click the New Relationship button. 

Next

How to Setup Data in Q

How to Stack Data Files