Add Table From File
From Array Suite Wiki
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:
Step 1: Select Source File Format
Selecting the "Add Table From File" option will present the following window:
Step 2: Locate Source File
Locate the file on your computer (local project) or server (server project), and click OK.
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
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.
After importing, the new table will appear in the Table section of the Solution Explorer.
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:
To learn how to force a column type when Adding Table from Tab delimited file or Excel file sources please see Force Column Types.