1.3.6.7 Length Profiler
The Length Profiler analyzes data values in any number of attributes and measures their length in number of characters.
Use the Length Profiler as a simple way of finding whether or not there are any values in an attribute with an inappropriate length.
The following table describes the configuration options:
| Configuration | Description |
|---|---|
|
Inputs |
Specify any String attributes that you want to measure for length. |
|
Options |
None. |
|
Outputs |
Describes any data attribute or flag attribute outputs. |
|
Data Attributes |
None. |
|
Flags |
The following flag is output:
|
The following table describes the statistics produced by the profiler. Note that each attribute is shown in a separate tab in the Results Browser.
| Statistic | Description |
|---|---|
|
Value |
.The value found. |
|
Count |
The number of times the value occurs in the attribute |
|
% |
The percentage of records analyzed with the value in the attribute. |
Example
In this example, the CU_ACCOUNT attribute on a table of Customer records is measured for its length.
The summary view:
| Length | Count | % (desc) |
|---|---|---|
|
13 |
332 |
16.5 |
|
12 |
304 |
15,1 |
|
14 |
293 |
14.6 |
|
15 |
243 |
11.9 |
|
11 |
217 |
10.8 |
|
16 |
197 |
9.8 |
|
10 |
136 |
6.8 |
|
17 |
103 |
5.1 |
|
9 |
60 |
3.0 |
|
18 |
44 |
2.2 |
|
19 |
20 |
1.0 |
|
8 |
13 |
0.6 |
|
20 |
11 |
0.5 |
|
7 |
10 |
0.5 |
|
21 |
9 |
0.4 |
|
6 |
6 |
0.3 |
|
22 |
4 |
0.2 |
The drill down view:
| CU_ACCOUNT | CU_ACCOUNT.CharLength |
|---|---|
|
00-23603-JD |
11 |
|
00-23615-PB |
11 |
|
00-23624-PB |
11 |
|
00-23631-JD |
11 |
|
00-23642-SH |
11 |
|
00-23658-SH |
11 |
|
00-23667-SH |
11 |
|
00-23675-SH |
11 |