Skip to main content

Tips & Tricks: Removing Double Entries from a Column/Row

When working with arcplan, there are different methods to generate a list without duplicates from a list of data with double entries. In many cases, a database consultation grouped accordingly may perform this task. Time and again, however, there are cases in which it is necessary to remove the duplicates with the assistance of arcplan functions. Two simple methods delivering the same end result are:

  • Use of the function UNITE()
  • Use of a hierarchy object

In the following, the two arcplan internal methods shall be illustrated by means of an example:

The starting situation is a column with city names which recur multiple times in the list.

Method 1: Function UNITE()



Method 2: Hierarchy Object