Table Stack.pdf
Stack Table
Overview
The Stack Table menu option allows the user to stack values from multiple columns into several rows in a column. It is the opposite of the Unstack Table menu option. It can be accessed by going to: Table | Stack:
Input Data Requirements
This command works on all “Table” objects, including Design Tables and Annotation Tables.
Step 1: Select the source table
The user will first be asked to choose the table to Stack:
Step 2: Stack
The "Stack Table" window is then presented, which contains all columns in the dataset that can be stacked. Using the arrow keys, selected columns can be moved to the "Stack columns" box. The order of these rows in the new Table can be adjusted by using the up and down arrow keys.
- Stack by row: The order of the data in the output table will be generated by by going through each row. If not checked, the order will follow the each column.
- Eliminate missing rows: Eliminates any rows that would end up missing in the stacked format.
- Drop non-stacked columns:Eliminates any columns that were not chosen to be stacked from the new Table.
- Stacked data column name: The name of the new Data column that is being created from the stacking.
- Source label column name: The name of the new column being created that contains the header names of the stacked columns.
- Output table name will set the name of the newly created Table in the Solution Explorer.
Output Results
A new table will be created in the Solution Explorer, stacking the columns as defined in Step 2. Please refer to Example Usage for specific case.
Example Usage
Orignally, the table_4 contains 4 samples (organized by column) and four genes (organized by row). The intensity is represented for each gene and sample by an integer.
Giving this stack option:
The Stack command converts the 4 sample columns into a single Sample column, with a new data column called Data.
Related Articles
