Difference between revisions of "Outer join (analysis)"

Revision as of 18:14, 9 December 2020

Analysis title

Outer join

Provider

geneXplain GmbH

Class

OuterJoin

Plugin

com.genexplain.analyses (geneXplain analyses)

Join tables

Combine two tables into a new one containing selected columns. Joining is processed according to ID matching from left and right tables. Result table will contain IDs presented at least in one table.

Parameters:

• Left Table - left (first table) for join.
  • Table - Table Data Collection from the Data tab in the Content Area.
  • Columns - Which columns from Table should be taken into account.
• Right Table - right (second table) for join.
  • Table - Table Data Collection from the Data tab in the Content Area.
  • Columns - Which columns from Table should be taken into account.
• Output table - Name of the table where results will be saved.

  If table with that name already exists it will be replaced.