Each table specified in the Selected Tables and Columns parameter in the scripting node produces a separate text file containing an ID column plus the list of columns specified in the node. The text file’s name is similar to the name of the table shown in the application. The text file is tab-separated with each entry encapsulated with quotes. The following figures show two tables produced with a Scripting Node exporting results from the Proteins and Pathway Protein Groups tables.
For any Distribution Map column, like the Abundance Ratio P-Value as shown in following figure, all of the subcolumns are exported. As a result, the number of columns that are exported to the text file for distribution map columns depends on the number of ratios or samples in any given dataset. The title of each column is the column name + subcolumn name.
The column header for Abundance Ratio P-value does not have the "/" character because you set the Use R-Friendly Headers parameter to True in the Scripting Node.
When the Scripting Node exports multiple tables, it exports additional files that map the associations between the tables. For example, when the Scripting Node exports the Proteins and Pathway Protein groups tables, it exports a second connection table that connects the proteins with their associated pathways by their ID values.
The following figure shows an example connection table that maps the associations between the Proteins and Pathway Protein Groups. The name of this connection table will include the two tables involved with the association. A connection table will be produced between each pair of tables selected in the Scripting Node parameters. As the number of tables selected for export in the Scripting Node increases, the number of connection tables will also increase accordingly.
The Use R-friendly Headers node parameter specifies whether the column names are the same as if they were generated by an ordinary text export using that option.