|
|
Process Help COUNT - count number of records for given key fields |
|
Process Name |
Menu Path |
Link to Command Table |
|
COUNT |
|
Introduction
Outputs a file containing each different value of a set of keyfields, and the number of occurrences of each value.
How to use
An up to five word keyfield is specified as 1-5 keyfield names. The output file contains these fields, together with a new field COUNT. This contains the number of occurrences of each set of keyfield values.
A typical use of COUNT is to find the number of samples in each drillhole (keyed on drillhole ID).
Files, Fields and Parameters
Input Files
|
Name |
Description |
I/O Status |
Required |
Type |
|
IN |
Input file, sorted on required keyfields. |
Input |
Yes |
Undefined |
Output Files
|
Name |
I/O Status |
Required |
Type |
Description |
|
OUT |
Output |
Yes |
Undefined |
File containing counts. Will contain specified keyfields + field COUNT holding number of keyfield combinations found. |
Fields
|
Name |
Description |
Source |
Required |
Type |
Default |
|
KEY1 |
Keyfield 1 for counting. |
IN |
Yes |
Any |
Undefined |
|
KEY2 |
Keyfield 2. |
IN |
No |
Any |
Undefined |
|
KEY3 |
Keyfield 3. |
IN |
No |
Any |
Undefined |
|
KEY4 |
Keyfield 4. |
IN |
No |
Any |
Undefined |
|
KEY5 |
Keyfield 5. |
IN |
No |
Any |
Undefined |
|
KEY6 |
Keyfield 6. |
IN |
No |
Any |
Undefined |
|
KEY7 |
Keyfield 7. |
IN |
No |
Any |
Undefined |
|
KEY8 |
Keyfield 8. |
IN |
No |
Any |
Undefined |
|
KEY9 |
Keyfield 9. |
IN |
No |
Any |
Undefined |
|
KEY10 |
Keyfield 10. |
IN |
No |
Any |
Undefined |
Notes
The field COUNT, if it exists in the input file, must not be used as a keyfield.
Example
!COUNT &IN(FILE1), &OUT(COUNT), *KEY1(BHID), @PRINT=1
(Listing of input file DD)(Listing of output file DD)
320 RECORDS READ
135 DIFFERENT KEY OCCURRENCES FOUND.
Error and Warning Messages
|
Message |
Description |
Solution |
|
>>> ERR 47 <<< ( 0) IN FNDKEY |
Warning; none of the specified key fields exist in the input file. An output file is produced with the field COUNT containing the number of records in the input file. |
|
|
|
|
|
|
>>> KEYFIELD nnnnnnnn MISSING FROM FILE ffffffff |
A warning message that is produced if @PRINT >=1. The keyfield is ignored and processing continues. |
|
|
|
|
|
