Combine

These blocks are used to combine values from different tables.

Notify pipeline completion

Notify pipeline completion

This block must be the last in a stack. It notifies join and join blocks that data is ready to be combined.

Join two pipelines

Join two pipelines

Join two tables by matching values in column X of table A to the values in column Y of table B. If table A contains:

X P
1 p1
2 p2
3 p3

and table B contains:

Y Q
1 q11
1 q12
3 q3
4 q4

then the final table contains rows for the matches 1 and 3:

_join_ A_P B_Q
1 p1 q11
1 p1 q12
3 p3 q3

The column _join_ contains the values that matched, while the other columns appear as table_column.

Concatenate two columns

Concatenate two columns

Take the values from column X of table A and the values from column Y of table B and create a new two column table:

table value
A X1
A X2
B Y1
B Y2