origin_merge_worksheets
Joins two worksheets on key columns (database-style merge) with inner, left, right, outer, or cross joins. Output to a new sheet or overwrite the left worksheet.
Instructions
Join two worksheets on key columns (database-style merge).
The left worksheet is book_name/sheet_name; the right is right_book/right_sheet. Specify the key with on (shared name) or with left_on plus right_on; when omitted, shared column names are used. how is inner, left, right, outer, or cross. Provide output_book/output_sheet to write to a new sheet instead of overwriting the left worksheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| right_book | No | ||
| right_sheet | No | ||
| on | No | ||
| left_on | No | ||
| right_on | No | ||
| how | No | inner | |
| book_name | No | ||
| sheet_name | No | ||
| output_book | No | ||
| output_sheet | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||