OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

2.2.3.48 wjoinbylabel

Brief Information

Join multiple worksheets by matching label row

Additional Information

Minimum Origin Version Required: 2015 SR0

Command Line Usage

wjoinbylabel irng:=[Book1](Sheet1,Sheet2) label:=L unmatch:=1 multiple:=1;

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input Worksheets irng

Input

Range

<unassigned>

This is used to specify the input worksheet range.

The syntax is: ([BookName]SheetName!, [BookName2]SheetName2!)

Matching Label Row label

Input

string

<unassigned>
Specify the Label Row by using its Label Row character.

Columns will be joined together according to their Label Row: including Long Name, Units, Comments etc.
Please refer to Column Label Row Characters for the single character of each column label row.
Wjoinbylabel-00.png

Drop Non-matches unmatch

Input

int

0
It specifies whether to drop columns (1=drop) with non-matches Label Row when multiple worksheets are joined into a single sheet.

Wjoinbylabel-1.png

Drop Multiples multiple

Input

int

0
Whether to keep only one column (1=keep only one) with matched Label Row (drop others) when more than one columns in one or more source worksheets have identical matched Label Row

Wjoinbylabel-2.png

Match with All Combinations combine

Input

int

0
It specifies whether to show (1=show) all combinations for columns with matched Label Rows when source worksheets join into single sheet.

Wjoinbylabel-3.png

Output Worksheet ow

Output

Worksheet

<new>
Specify the output range, see syntax here.

Description

This X-Function is used to join multiple worksheets into a single worksheet by matching label row, according to the method specified.

Related X-Functions

wAppend, wjoinbycol


Keywords:merge, combine

 

© OriginLab Corporation. All rights reserved.