This article describes how to combine two or more separate tables into a single merged table by combining either common row labels or common column labels. When combining tables by rows a side-by-side join direction is used. When combining tables by column a stacked un and down join direction is used.
Requirements
- A document containing two or more tables that you want to combine.
- Familiarity with the Structure and Value Attributes of Variable Sets as sometimes you can combine similar variables into a Multi or Grid variable set to show their data in the same table.
Method 1 - Using the combine button
1. Select each of the tables in your document that you want to merge by holding down your Ctrl key and selecting each table. In this example, we have 2 brand preference tables, each with the same row labels (brand), but with different column labels - the first table is cross-tabbed by age and the second by gender.
2. From the toolbar menu, select Combine > As Table. Displayr will automatically determine that the row labels are the same in each table and combine the tables with a side-by-side join direction.
Method 2 - Using the Anything menu
- Select the tables you want to combine on the page.
- Go to Anything > Table > Combine Tables.
Method 3 - Using the Table menu
- Select the tables you want to combine on the page.
- Go to Table > Combine Tables.
When using this function, it is important to be aware of the following:
- The joined table is generated using an R function.
- Significance testing from the original tables will not be displayed in the combined table.
- You can modify the default inputs (i.e., add or remove input tables, change the join direction, etc.) by selecting the combined and table and modify the input selections in the object inspector on the right.
-
- Join direction - Whether to join the tables side-by-side (must have some rows in common) or up-and-down (must have some columns in common).
- Non-matching rows/columns: The tables that you are merging might have row (or column) names that do not match. This option allows you to specify how to handle the non-matches.
- Keep all - Keep all rows from the tables. Rows that do not match the other tables will be blank.
- Matching only - Keep only the rows that are common between the tables.
- If one or more of the input tables contain multiple statistics, only the first statistic will be used. In this situation. a warning message will be displayed above the object inspector:
Next
How to Combine Tables with Multiple Statistics
Comments
0 comments
Article is closed for comments.