Table ColumnProperties.pdf

From Array Suite Wiki
(Redirected from ColumnProperties.txt)

Column Properties

Overview

The Column Properties menu item allows users to set the properties of each column in an individual table.

It can be accessed by going to Table | Columns | Column Properties.

Table ColumnProperties Menu.png

Input Data Requirements

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

Step 1: Select the table

The user will first be asked to choose the table for which to edit column properties:

Tips.pngColumn properties can also be accessed directly from a Table by right-clicking a Column header.

SelectData0.png

Step 2: Change Properties

The user is then presented with the "Column Properties" window:

ColumnProperties1.png

On the left side of the screen, the user can select the column (or columns) to edit the properties. The right side of the screen includes the properties that can be set which are discussed below.

Important: the "Column Type" property can be very important in Array Studio, as many of the analysis options are only available if a column is set to a specific type (i.e. continuous covariates would need to be set to a numeric value, or if a column is a "Factor" then the type should be set to "Factor"). Editing the Column Properties before attempting an analysis will be an important step in learning how to successfully analyze data in Array Studio. By default, Array Studio makes an educated guess as to the Column Type for a table, but it is not always correct. The Column Mode property is also something the advanced Array Studio user should understand.

Appearance

  • Alignment: Opens a dropdown box so the user can set the alignment of the column(s) within the table. The options include; "NotSet", "TopLeft", "TopCenter", "TopRight", "MiddleLeft", "MiddleCenter", "MiddleRight", "BottomLeft", "BottomCenter", "BottomRight".
  • Background Color: Opens a window to allow the user to select the background color for the column or columns in the table.
  • Bold: True/False setting that sets a Bold attribute if set to true for the column or columns in the table.
  • Float Precision: For columns set to a numeric type, allows the user to set the precision of the floating number, via a dropdown box. Available options include "Default", "Full", "ZeroDigit", "OneDigit", "TwoDigit", "ThreeDigit", "FourDigit", "FiveDigit", "SixDigit", "SevenDigit", "EightDigit", "NineDigit", and "TenDigit".
  • Foreground Color: Opens a window to allow the user to sets the foreground color for the column or columns in the table (only applies to views where foreground color is available).
  • Italic: True/False setting that sets an Italic attribute if set to true for the column or columns in the table.
  • Underline: True/False setting that sets an underline attribute if set to true for the column or columns in the table.

General

  • Column Type (ColumnType): Allows the user to select the Column Type for each column in a table. The "Column types" include "Character", "Factor", "Double", "Float"," Integer", "Boolean", "NameList", "DateTime", "Annotation", "CellIndex", "Readout", "ConfidenceIntervalReadout", "Thumbnail", "Generic", and "NotSet".
    • Important: the Column Type property can be very important in Array Studio, as many of the analysis options are only available if a column is set to a specific type (i.e. continuous covariates would need to be set to a numeric value, or if a column is a Factor then the type should be set to Factor). Editing the Column Properties before attempting an analysis will be an important step in learning how to successfully analyze data in Array Studio. By default, Array Studio makes an educated guess as to the Column Type for a table, but it is not always correct.
  • Group: The Group options is used for Inference Reports, in order to group contrast (or tests/ratios) columns together. Many times there will be 4 or more columns associated with a particular test, and this setting is how Array Studio recognizes this. When importing inference report tables from outside Array Studio and expecting to be able to visualize these reports with some of Array Studio’s advanced graphics, this setting must be used.
  • Column Mode (ColumnMode): Allows the user to select the "Column Mode" for each column in a table. "Column modes" include "RawPvalue", "AdjustedPValue", "GeneralPValue", "LSMean", "FoldChange", "Estimate", "Odds Ratio", "Statistic", "FamilyID", "IndividualID", "FatherID", "MotherID", "Sex", "Phenotype", "Chromosome", "GeneticDistance", "BasePairPosition", "BasePairePosition2", "PlateID", "ArrayID", "Channel", "FileName", "FileID", "ObservationID", "VariableID", "TranscriptID", "ExonID", "CNStatus", "AlleleA", "AlleleB", "Alleles", "Genotypes", "Image", or "NotSet".
    • Important: These modes are used by Array Studio in a number of different analysis and visualizations. It is important not to change the mode unless the user is sure that what they are doing is correct, as changing to an incorrect mode could have an undesirable effect.
    • Reasons for changing the mode could be that the user imported data from outside Array Studio and wants to use Array Studio’s advanced visualization and analysis functions on this data.
  • Name: Box to set the name for a column or columns in table.
  • Selected: True/False setting that allows the user to select whether a particular column or columns.


Output Results

After changing properties, the selected columns will change display as specified.

Change Properties in Bulk

It is also possible to update properties in bulk by right clicking on the table in the Solution Explorer and selecting Change Column Properties By File

ChangeColumnPropertiesByFile.png

And selecting a tab delimited file where the first column's values are the names of the columns whose properties you wish to set like:

ColumnID	Alignment	Bold
Gene Symbol	TopCenter	True
Gene Title	TopRight	False


EnvelopeLarge2.png