123456789101112131415161718192021222324252627282930 |
- /*##############################################################################
- HPCC SYSTEMS software Copyright (C) 2012 HPCC Systems®.
- Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License.
- You may obtain a copy of the License at
- http://www.apache.org/licenses/LICENSE-2.0
- Unless required by applicable law or agreed to in writing, software
- distributed under the License is distributed on an "AS IS" BASIS,
- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- See the License for the specific language governing permissions and
- limitations under the License.
- ############################################################################## */
- namesRecord :=
- RECORD
- string20 surname;
- string10 forename;
- integer2 age := 25;
- END;
- namesTable1 := dataset('x',namesRecord,FLAT);
- namesTable2 := group(namesTable1, surname);
- p := IF(count(namesTable1) > 100, namesTable1, namesTable2);
- output(p);
|