https://wiki.biouml.org/index.php?action=history&feed=atom&title=Join_two_tables_%28analysis%29 2026-04-13T10:08:43Z Revision history for this page on the wiki MediaWiki 1.20.3 https://wiki.biouml.org/index.php?title=Join_two_tables_(analysis)&diff=9062&oldid=prev 2020-12-09T11:15:32Z

<p>Protected &quot;<a href="/index.php/Join_two_tables_(analysis)" title="Join two tables (analysis)">Join two tables (analysis)</a>&quot;: Autogenerated page (‎[edit=sysop] (indefinite))</p> <table class='diff diff-contentalign-left'> <tr style='vertical-align: top;'> <td colspan='1' style="background-color: white; color:black;">← Older revision</td> <td colspan='1' style="background-color: white; color:black;">Revision as of 11:15, 9 December 2020</td> </tr></table>

WikiBot https://wiki.biouml.org/index.php?title=Join_two_tables_(analysis)&diff=9058&oldid=prev 2020-12-09T11:15:31Z

<p>Automatic synchronization with BioUML</p> <p><b>New page</b></p><div>;Analysis title<br /> :[[File:Table-manipulation-Join-two-tables-icon.png]] Join two tables<br /> ;Provider<br /> :[[Institute of Systems Biology]]<br /> ;Class<br /> :{{Class|ru.biosoft.analysis.JoinTable}}<br /> ;Plugin<br /> :[[Ru.biosoft.analysis (plugin)|ru.biosoft.analysis (Common methods of data analysis plug-in)]]<br /> <br /> === Join tables ===<br /> <br /> Combine two tables into a new one containing selected columns. Joining is processed according to ID matching from left and right tables.<br /> <br /> Columns with the same names can be merged if the respective option is checked. Otherwise column name will be extended by table name for both input tables and two distinct columns will be taken to the resulting table.<br /> <br /> ==== Parameters: ====<br /> <br /> * '''Left Table''' - left (first table) for join.<br /> ** '''Table''' - a table data collection stored in BioUML repository.<br /> ** '''Columns''' - the columns from the table which should be taken into account.<br /> * '''Right Table''' - right (second table) for join.<br /> ** '''Table''' - a table data collection stored in BioUML repository.<br /> ** '''Columns''' - the columns from the table which should be taken into account.<br /> * '''Join type''' - the type of join:<br /> ** '''Inner''' - inner join in SQL sense (result will contain IDs presented in both tables).<br /> ** '''Outer''' - full outer join in SQL sense (result will contain IDs presented at least in one table).<br /> ** '''Left''' - left outer join in SQL sense (result will contain IDs presented in left table).<br /> ** '''Right''' - right outer join in SQL sense (result will contain IDs presented in right table).<br /> ** '''Left substraction''' - result will contain IDs presented ONLY in left table.<br /> ** '''Right substraction''' - result will contain IDs presented ONLY in right table.<br /> ** '''Symmetric Difference''' - result will contain IDs presented only in one (any) of two tables.<br /> * '''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.<br /> <br /> [[Category:Analyses]]<br /> [[Category:Table manipulation (analyses group)]]<br /> [[Category:ISB analyses]]<br /> [[Category:Autogenerated pages]]</div>

WikiBot