% @(#)group_row.hlq 17.1.1.1 (ESO-IPG) 01/25/02 17:50:00 %++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ %.COPYRIGHT (c) 1993 European Southern Observatory %.IDENT group_row.hlq %.AUTHOR 05-MAY-93, IPG/ESO %.KEYWORDS MIDAS, help files, %.PURPOSE On-line help file for the command: GROUP/ROW %.VERSION 1.0 MP : Creation, 05-MAY-93 %---------------------------------------------------------------- \se SECTION./ROW \es\co GROUP/ROW MP 05-MAY-93 \oc\su GROUP/ROW table incol outcol group the rows of a table by the value of one of its column \us\pu Purpose: group the rows of a table that have the same value in a given column and assign to them a group number (integer) that is stored into an output column \up\sy Syntax: GROUP/ROW table incol outcol \\ \ys\pa table = table name \\ \ap\pa incol = reference of the input column \\ \ap\pa outcol = output column (will be created if it doesn't exist) \\ \ap\sa See also: \as\no Note: The input column may be of any type. If it contains floating point numbers (R*4 or R*8), the row values are truncated before being grouped. \on\exs Examples: \ex GROUP/ROW ntt :EXPTYPE :EXPTYPE_G group the rows of the table ntt that have the same value in the column EXPTYPE and store the group number into the column EXPTYPE_G \xe \sxe