Add Table From File

From Array Suite Wiki

Jump to: navigation, search

Contents

Add Table From File

Array Studio can import table data from multiple sources. To access these methods, click Add Data | Add Table Data | Add Table From File:

AddTableFromFile Menu.png

Step 1: Select Source File Format

Selecting the "Add Table From File" option will present the following window:

AddTableFromFile SpecifyTableSource.png

[back to top]

Step 2: Locate Source File

AddTableFromFile LocateFile.png

Locate the file on your computer (local project) or server (server project), and click OK.

[back to top]

Step 3: Specify Format-Specific Import options

The available file types for uploading include Tab delimited, Comma delimited, stacked delimited files, Excel spreadsheets, SAS dataset file, bed files, and Generic text files.

Tab delimited file, Comma delimited file, and Excel file

The process for adding a tab delimited file, comma delimited file, and Excel file as table data is the same except that for an Excel file, you will be asked to choose the Sheet to import.

After selecting the table for import, the table will appear in the Table section of the Solution Explorer.

Tab or Comma-delimited, Unstack

UnstackTableImport.png

If the user would like to unstack a "tall-skinny" table by cell contents into adjacent columns, Array Studio will prompt the user to specify the "Split by", "split columns", and "Group columns".

For more details on unstacking tables, please see Unstacking Tables.

Be default, each column will include a label that indicates which row from the specified "Split By" column the data came from. If this information isn't needed, uncheck "Prepend value columns with original column name".

SAS dataset file

If users have SAS software installed, SAS-dataset files can be imported.

Generic text file

Using the generic text file option gives the user a little more flexibility in importing Table data. It allows the user to set the type of delimiter being used (including tab, space, comma, colon, slash, backslash, semicolon, or other), combine continuous delimiters, generate row header, generate column header, or Parse columns.

BED file (UCSC)

Users can import tables that conform to UCSC BED format (without header line). The first three columns will be stored as "Chromosome" and "BasePairPosition" column types; subsequent columns are generic "Character" or "Long" types.

[back to top]

Output Results

After importing, the new table will appear in the Table section of the Solution Explorer.

Users can use Table functions to modify or add columns, or can convert to an -Omic data object by right-clicking the Table object and selecting Convert to Microarray.

[back to top]


Forcing Column Types

Inside Omicsoft, each table column has column properties which define Column Type. Right click on the column headers to bring up a Column Properties menu:

ColumnProperties.png

To learn how to force a column type when Adding Table from Tab delimited file or Excel file sources please see Force Column Types.

OmicScript

[[]]

Related Pages

[back to top]

EnvelopeLarge2.png