Table Stack.pdf

From Array Suite Wiki
(Redirected from StackTable.txt)

Stack Table

Table StackTable Schematic.png

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:

Table Stack Menu.png

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:

SelectData2.png

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.

StackTable1.png

  • 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.

StackTable3.png

Giving this stack option:

StackTable1.png

The Stack command converts the 4 sample columns into a single Sample column, with a new data column called Data.

StackTable2.png


Related Articles

EnvelopeLarge2.png