Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
This operator joins tables based on columns in the parameters. Columns used for joining must be present in all tables, and they should not include other common fields like lhub_id and lhub_page_num.
...
Output
Output of joined tables is returned
Example
table1
:
col1 | col2 | Feature_1 |
---|---|---|
1 | 2 | f1 |
3 | 4 | f2 |
table2
:
col1 | col2 | Feature_2 |
---|---|---|
3 | 4 | g1 |
5 | 6 | g2 |
Example1
:
LQL
Code Block |
---|
joinTables([table1, table2], ["col1", "col2"], "inner") |
Output1
:
col1 | col2 | Feature_1 | Feature_2 |
---|---|---|---|
3 | 4 | f2 | g1 |
Example2
:
LQL
Code Block |
---|
joinTables([tab1e, table2], ["col1", "col2"], "outer") |
Output2
:
col1 | col2 | Feature_1 | Feature_2 |
---|---|---|---|
1 | 2 | f1 | |
3 | 4 | f2 | g1 |
5 | 6 | g2 |