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

From BioUML platform
Jump to: navigation, search
(Automatic synchronization with BioUML)

Revision as of 18:15, 9 December 2020

Analysis title
Table-manipulation-Join-two-tables-icon.png 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.
Personal tools
Namespaces

Variants
Actions
BioUML platform
Community
Modelling
Analysis & Workflows
Collaborative research
Development
Virtual biology
Wiki
Toolbox