Difference between revisions of "Join table (analysis)"
From BioUML platform
(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
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.
