2.2.3.49 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