cross_workbook_lookup
Enrich a source workbook by matching rows against one or more lookup workbooks, pulling selected columns into the dataset. Configure keys, join type, and match mode for precise control.
Instructions
Enrich one workbook dataset from matching rows in one or more lookup workbooks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| select | No | ||
| row_mode | No | arrays | |
| join_type | No | left | |
| lookup_key | No | ||
| match_mode | No | first | |
| source_key | Yes | ||
| schema_mode | No | strict | |
| infer_schema | No | ||
| lookup_select | No | ||
| case_sensitive | No | ||
| lookup_sort_by | No | ||
| source_filepath | Yes | ||
| lookup_filepaths | Yes | ||
| lookup_sort_desc | No | ||
| lookup_header_row | No | ||
| lookup_sheet_name | No | ||
| lookup_table_name | No | ||
| source_header_row | No | ||
| source_sheet_name | No | ||
| source_table_name | No | ||
| lookup_sample_limit | No | ||
| include_lookup_match_count | No | ||
| include_lookup_source_columns | No |