Page tree
Skip to end of metadata
Go to start of metadata

(The following is an include of the English version of this page, Identifier instances)


Summary

Finds an identifier in one or more columns. The different instances (= values) of a column and/or several columns are displayed.

Example: Using "Identifier instances"

Situation

The following data node contains information on employee, customer and sales figures in different locations (column F).

We want to count how many locations there are, and how many times each employee count exists in the data.

Settings

Add the operator "Identifier instances" to the data node. Choose which column you would like to count
(in this case, the Identifier in column F), and if you would like the results to be sorted.

Result

Identifier = F results in the following data node:

Identifier = C results in the following data node:

Identifier = C, F results in the following data node (combinations):

Want to learn more?

Finds an identifier in one or more columns. The different instances (= values) of a column and/or several columns are displayed.

Columns of input table

ParameterValueOpt.DescriptionExample
Identifier

System.Object

-Which columns should be evaluated for the identifier?-

Parameter

ParameterValueOpt.DescriptionExample
Case-sensitive?

System.Boolean

opt.When checking for sameness, should upper and lower case letters be considered?-
Additional column for data record definitions

System.Boolean

opt.Should an additional column showing the number of duplicate data records be output?-
Sort result according to the number of data records?

System.String

  • No sorting
  • Sort ascending
  • Sort descending
opt.Should the result be sorted by the number of identical data records?-

 

 

Please make sure if "case sensitive" should be checked or not, especially when using this operation in combination with others (e.g., Merge data 4.0).

 

Related topics

  • ...