You are here: Processor Library > Profiling > Length Profiler

Length Profiler

The Length Profiler analyzes data values in any number of attributes and measures their length in number of characters.

Use

Use the Length Profiler as a simple way of finding whether or not there are any values in an attribute with an inappropriate length.

Any String attributes that you wish to measure for length.

None

None

Flag attribute

Purpose

Possible Values

[Attribute Name].CharLength

Indicates the number of characters in the attribute

The Number of characters.

The Length Profiler produces a Summary View of its results, showing the following statistics.

Note that each attribute is shown in a separate tab in the Results Browser.

Statistic	Meaning
Length	Each distinct length in characters for which values exist
Count	The number of records with values in the attribute with the given length
%	The percentage of records with values in the attribute with the given length

In this example, the CU_ACCOUNT attribute on a table of Customer records is measured for its length:

Summary View

Drill Down View