Difference between revisions of "Join table (analysis)"

From BioUML platform
Jump to: navigation, search
(Automatic synchronization with BioUML)
 
(Class name added)
 
(10 intermediate revisions by one user not shown)
Line 1: Line 1:
 +
;Analysis title
 +
:[[File:Data-Join-table-icon.png]] Join table
 +
;Provider
 +
:[[Institute of Systems Biology]]
 +
;Class
 +
:{{Class|ru.biosoft.analysis.JoinTable}}
 +
;Plugin
 +
:[[Ru.biosoft.analysis (plugin)|ru.biosoft.analysis (Common methods of data analysis plug-in)]]
 +
 
=== Join tables ===
 
=== Join tables ===
  
Line 25: Line 34:
 
[[Category:Analyses]]
 
[[Category:Analyses]]
 
[[Category:Data (analyses group)]]
 
[[Category:Data (analyses group)]]
 +
[[Category:ISB analyses]]
 +
[[Category:Autogenerated pages]]

Latest revision as of 11:14, 31 May 2013

Analysis title
Data-Join-table-icon.png Join table
Provider
Institute of Systems Biology
Class
JoinTable
Plugin
ru.biosoft.analysis (Common methods of data analysis plug-in)

[edit] 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.

[edit] 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