Difference between revisions of "Join two tables (analysis)"

Revision as of 18:15, 9 December 2020

Analysis title

Join two tables

Provider

Institute of Systems Biology

Class

JoinTable

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.

Columns with the same names can be merged if the respective option is checked. Otherwise column name will be extended by table name for both input tables and two distinct columns will be taken to the resulting table.

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.