| 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 |