|
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. |