Table Unstack.pdf

From Array Suite Wiki
(Redirected from UnstackTable.txt)

Unstack Table

Overview

The Unstack Table menu option allows the user to "unstack" values from multiple rows into several columns in a row. It is the opposite of the "Stack" command. It can be accessed by going to: Table | Unstack.

UnstackTable111.png

Input Data Requirements

This command works on all “Table” objects, including Design Tables and Annotation Tables.

Warning.png WARNING: The table should contain an ID column in the first column, which will not be split or grouped in the destination table.


Step 1: Select the source table

The user will first be asked to choose the table to Unstack:

SelectData3.png

Step 2: Specify columns to split and group

The user is then presented with the "Unstack Table" window displaying "Columns in the table" box. This contains any columns in the dataset that can be used for the purposes of unstacking.

UnstackTable1.png

  1. Pick the Split by column, using the dropdown box. The Split by column determines the columns in the new Table.
  2. Select the Split columns which determines the factor(s) to be split (cell contents in the new table).
  3. (Optional) Select Group columns, that when combined with the Split column(s) will determine rows in the new table.
  • Keep remaining columns: When checked, will ensure that any columns not used in the unstacking process (Split by, Split columns, Group columns) will be kept and brought over to the new table.
  • Output table name: Name the newly created Table object.


Output Results

A new table will be created in the Solution Explorer, unstacking the rows as defined in Step 2. Please refer to Example Usage for a specific case.

Example Usage

An example of the Unstack command is shown below. In the first picture, the table contains a Sample column (with 4 samples), an Intensity column, and a Gene column.

Warning.png WARNING: The table also should contain an ID column in the first column, which will not be split or grouped in the destination table.


Unstack1.png

Using the Unstack function by specifying "Split by" Sample, "Split columns" Intensity, and "Group columns" Gene

Unstack2.png

The "Unstack" command converts the table into a new Table object with one column for each sample.

Unstack3.png

Video Examples

Coming Soon

Related Articles

EnvelopeLarge2.png