|
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. |
|
|
|
|