Difference between revisions of "Join table (analysis)"

Revision as of 11:47, 6 May 2013

Analysis title

Join table

Provider

Institute of Systems Biology

Plugin

ru.biosoft.analysis (Common methods of data analysis plug-in)

Join tables

Combine two tables into a new one containing selected columns. Joining is processed according to ID matching from left and right tables.

Note: for each column from input tables you can select new name which it will have in result table to avoid coincidence in column names.

Parameters:

• Left Table - left (first table) for join.
  • Table - a table data collection stored in BioUML repository.
  • Columns - the columns from the table which should be taken into account.
• Right Table - right (second table) for join.
  • Table - a table data collection stored in BioUML repository.
  • Columns - the columns from the table which should be taken into account.
• Join type - the type of join:
  • Inner - inner join in SQL sense (result will contain IDs presented in both tables).
  • Outer - full outer join in SQL sense (result will contain IDs presented at least in one table).
  • Left - left outer join in SQL sense (result will contain IDs presented in left table).
  • Right - right outer join in SQL sense (result will contain IDs presented in right table).
  • Left substraction - result will contain IDs presented ONLY in left table.
  • Right substraction - result will contain IDs presented ONLY in right table.
  • Symmetric Difference - result will contain IDs presented only in one (any) of two tables.
• Output table - the path in BioUML repository where the result table will be stored. If a table with the specified path already exists it will be replaced.