Difference between revisions of "Join several tables (analysis)"
From BioUML platform
(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 |
| − | * '''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: | + | [[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
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
