...
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.
Operator Usage in Easy Mode
- Click + on the parent node.
- Enter the Join Tables operator in the search field and select the Join Tables operator from the Results to open the operator form.
- In the Tables drop-down, enter or select a table or a list of tables to join.
- In the Columns field, click Add More to add the list of columns to join tables. These columns must be present in all tables.
- In the Join Type field, enter the join type of the columns.
- Click Run to view the result.
- Click Save to add the operator to the playbook.
- Click Cancel to discard the operator form.
Usage Details
LQL
Code Block |
---|
joinTables(tables, columns, joinType) |
...
Output
Output of joined tables is returned
Example
table1
:
col1 | col2 | Feature_1 |
---|---|---|
1 | 2 | f1 |
3 | 4 | f2 |
...