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

From BioUML platform
Jump to: navigation, search
(Added 'Autogenerated pages' category)
(Automatic synchronization with BioUML)
 
(10 intermediate revisions by one user not shown)
Line 1: Line 1:
 +
;Analysis title
 +
:[[File:Table-manipulation-Join-several-tables-icon.png]] Join several tables
 +
;Provider
 +
:[[Institute of Systems Biology]]
 +
;Class
 +
:{{Class|ru.biosoft.analysis.MultipleTableJoin}}
 +
;Plugin
 +
:[[Ru.biosoft.analysis (plugin)|ru.biosoft.analysis (Common methods of data analysis plug-in)]]
 +
 +
==== Description ====
 
Intersect or join two and more tables. All column will be taken to the result.
 
Intersect or join two and more tables. All column will be taken to the result.
  
Line 4: Line 14:
  
 
* '''Input tables''' – Input tables
 
* '''Input tables''' – Input tables
* '''join type''' – Type of join
+
* '''Join type''' – Type of join
* '''Merge columns with the same names''' (expert) – Merge columns with the same names
+
* '''Merge columns with the same names''' – Merge columns with the same names
 +
* '''Ignore empty values''' (expert) – Ignore empty values during aggregator work
 
* '''Aggregator for numbers''' (expert) – Function to be used for numerical columns when several rows are merged into a single one if merge columns option is selected
 
* '''Aggregator for numbers''' (expert) – Function to be used for numerical columns when several rows are merged into a single one if merge columns option is selected
 
* '''Output table''' – Output table
 
* '''Output table''' – Output table
  
 
[[Category:Analyses]]
 
[[Category:Analyses]]
[[Category:Data (analyses group)]]
+
[[Category:Table manipulation (analyses group)]]
 +
[[Category:ISB analyses]]
 
[[Category:Autogenerated pages]]
 
[[Category:Autogenerated pages]]

Latest revision as of 18:15, 9 December 2020

Analysis title
Table-manipulation-Join-several-tables-icon.png Join several tables
Provider
Institute of Systems Biology
Class
MultipleTableJoin
Plugin
ru.biosoft.analysis (Common methods of data analysis plug-in)

[edit] Description

Intersect or join two and more tables. All column will be taken to the result.

[edit] Parameters:

  • Input tables – Input tables
  • Join type – Type of join
  • Merge columns with the same names – Merge columns with the same names
  • Ignore empty values (expert) – Ignore empty values during aggregator work
  • Aggregator for numbers (expert) – Function to be used for numerical columns when several rows are merged into a single one if merge columns option is selected
  • Output table – Output table
Personal tools
Namespaces

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