2.2.3.56 wkeepdup

Contents

Brief Information

Reduce rows by checking for duplicates in reference column

Command Line Usage

wkeepdup num:=2

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

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
 Obsolete since Origin 2024b, use XF switch "-u" instead.
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