...
The x-function, wjoinbycol, enable joining worksheets by the matched column in Origin 2015.
Detailed Documentation: Please refer the wjoinbycol help page
How to:
- When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
In the Script Window, enter script below and press Enter
Code Block wjoinbycol -d
Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Input Worksheets | irng | Input Range | Specify the worksheets to be joined. For example, join the sheet1 in Book1 and Book2
| |
| Matching Columns | condition | Input string | Specify the matched columns in each sheet, use = as connector. For example, condition:= | |
| Drop Multiples | multiple | Input int | 0 | Only include the first match found with multiple:=1
|
| Drop Non-matches | unmatch | Input int | 0 | Only include the matched values with unmatch:=1
|
| Match with All Combinations | combine | Input int | 1 | Show all combinations when there is multiple match cells with combine:=1, like the following ID=a
|
| Merge Matched Column as One | merge | Input int | 1 | Only keep one matched column in result with merge:=1
|
| Consider Missing Values | missing | Input int | 0 | Specify to decide whether to ignore rows with missing values in the matching columns. |
| Output | orng | Output Worksheet | Specify the output worksheet |
...
Join Worksheet by Matching Labels
ORG-11420
The x-function, wjoinbylabel, enable joining worksheets by the matched label (worksheet headers)
Detailed Documentation: Please refer the wjoinbylabel help page
How to:
- When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
In the Script Window, enter script below and press Enter
Code Block wjoinbylabel -d