Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. Click + on the parent node.
  2. Enter the Join Tables operator in the search field and select the Join Tables operator from the Results to open the operator form.
  3. In the Tables drop-down, enter or select a table or a list of tables to join.
  4. In the Columns field, click Add More to add the list of columns to join tables. These columns must be present in all tables.
  5. In the Join Type field, enter the join type of the columns.
  6. Click Run to view the result.
  7. Click Save to add the operator to the playbook.
  8. 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:

col1col2Feature_1
12f1
34f2

...