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

From BioUML platform
Jump to: navigation, search
(Adding provider-specific categories)
(Automatic synchronization with BioUML)
 
(7 intermediate revisions by one user not shown)
Line 1: Line 1:
 
;Analysis title
 
;Analysis title
:Join several tables
+
:[[File:Table-manipulation-Join-several-tables-icon.png]] Join several tables
 
;Provider
 
;Provider
 
:[[Institute of Systems Biology]]
 
:[[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 ====
 
==== Description ====
Line 10: 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: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