2.2.3.50 wkeepdup

Brief Information

Reduce rows by checking for duplicates in reference column

Command Line Usage

wkeepdup num:=2

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Reference Column irng

Input

Range

<active>
Specify the column in which duplicated rows will be searched for.
Minimum Number of Duplicate to Keep num

Input

int

2
Specify the minimum number of duplicated rows to keep. If the number of duplications of a row value is less than this value, the row will not be kept.
Case Sensitive sensitive

Input

int

0
Specify whether the duplication checking is case-sensitive.
Support Undo undo

Input

int

1
Specify whether to enable "undo". Note: This variable is designed for the script usage only, and is not available from dialog.
Output Worksheet ow

Output

Worksheet

<input>
Specify the worksheet in which to output the duplicated rows.


See the syntax here.

Description

In the num variable, specify the minimum number of duplicated rows to keep. If the number of duplications of a row value is less than the value of num, the row will not be kept.

Related X-Functions

wdeldup


Keywords:data reduction