Reference
 Overview
 Workspace
 Graphs
 Platforms
 Output
 Techniques
 Menus
Prefs_ElementalButton.gif
Search :
more..
 Tables
A requirement of many experiments is the ability to generate tabular output for further analysis in a spreadsheet or statistics program. The table editor is the means by which you can generate a series of statistical calculations for all samples in a group. These statistics can be any of the statistics FlowJo calculates: medians, frequencies, etc. In order to generate a table, you will first have to generate the statistics you wish to export on at least one sample.

From the workspace window, open the table editor. This can be done in one of two ways: either click on the table editor function button in the workspace window (the fourth button in the top left corner), or select the table window from the Windows menu. This will bring up the table view window, from which you can easily create previously-defined table outputs.

Use the Table Editor to define a new table definition. A table definition is not the output data itself.  Instead it is the specification of what columns the table will contain, when it is generated.  You can have as many table definitions in the workspace as you wish.  You can create new empty definitions, Keywords.  The table editor also supports including sample file keywords. A keyword is any attribute listed in the text section of the FCS file.  Above the list of columns is a button with a picture of a key on it.  Press this button to bring up a dialog which will allow you to select the keyword(s) to be included in the table.  You can use shift- and ctrl- clicking to selection multiple items from the list. Keywords are appended to the table definition. There is a list of standard keywords, as defined by the FCS specification. Note that not all files will contain all keywords.

Generating the Table. Once you have put all the desired statistics and keywords into the table definition, click on the Table button in the top right corner of the definition window. This will invoke the table generation process. FlowJo will cycle through all of the samples in the current group, and calculate all possible statistics and keywords that are in the table definition. It will then create a new window containing a spreadsheet-like view of the statistics. This table can be saved to the clipboard or a file, or printed. Each of these operations is initiated via File menu.

Column Names.  In the output file, the first line has a tab-delimited list of column names.  Each column name is a concatenation of the full name of the population (including all "parents") and the statistic name itself.  For example, "Lymphocytes/CD4:Freq. of Parent" would be the name for the column with the frequencies of CD4 cells within the Lymphocyte gate.  These names can become unwieldy in length... you might want to keep your subset names as short as possible.  In addition, you can have FlowJo export abbreviated statistic names (in the example above, "Freq. of Parent" would be replaced by "%P").  You can set this preference in the Preferences for Tables & Layouts.

Replace Column Names. You can type in any name you wish to replace the statistic names in the generated table. In the Table Editor, type in the new names in the "Column Name" column. When you create a table, these names will be displayed instead of FlowJo's statistic name.

[Reference] [Overview] [Workspace] [Graphs] [Platforms] [Output] [Techniques] [Menus] [Preferences]