Skip to content

Draft: Add Join Tables Filter

The Join Tables Filter is a filter that operates on two Table objects to perform an SQL-style Join operation. It outputs one Table object. The goal is to combine the rows of both tables into one bigger table based on a related "key column" between them. The two input tables are referred to as left and right. In each input table, the values in the key column act like unique IDs for their respective rows. During the merge, the attributes of each item will be given with respect to its ID. Below is an example of a basic join operation :

First input Table (left)

Name Age Sex
Alex 25 M
Beth 41 F
Cory 33 M

Second input Table (right)

Name Height(cm) Weight (kg)
Cory 184 88
Alex 175 74
Beth 168 70

Result of a Join operation performed with LeftKey = "Name"and RightKey = "Name" :

Name Age Sex Height(cm) Weight (kg)
Alex 25 M 175 74
Beth 41 F 168 70
Cory 33 M 184 88

This Filter exposes the following parameters :

  • Join Mode {intersection, union, left, right} : specifies which Join method to perform. This is useful when the key columns do not share exactly the same values. left keeps the keys of the left input table, right keeps the keys of the right input table, intersection keeps only the keys that are present in both tables, union keeps the keys from both tables.
  • Left Key (array list combo box) : Column name of the left table to treat as key
  • Right Key (array list combo box) : Column name of the right table to treat as key

Merge request reports