cross_workbook_lookup
Enrich a workbook dataset with matching rows from one or more lookup workbooks. Specify a source key to pull relevant fields and combine data across files.
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 |