mapList

The mapList() function groups a list of values according to a specified mapping. The mapping array consists of hybrid alternating name-value pairs or [name array]-value pairs.

mapList(list, mapping_array, 'options string')

e.g., mapList(q['State'],[['AZ','CA'],'West',['NY','NJ'],'East'])

The options string values are as follows (multiple options are separated by a comma delimiter):

others=groupOthers/leaveOthers: Group all unmapped values in a generic group called 'Others' (groupOthers), or display each unmapped value as its own group (leaveOthers). Default is 'groupOthers'.

sort=asc/desc/false: Sort the values in ascending or descending order. Default is false.

remainder: Specifies the label for the 'Others' group when Top/Bottom-N filtering is in effect. If not specified, the 'Others' group is not displayed.

distinct=true/false: Retrieve only distinct values. Default is false.

<< rowList © 1996-2013 InetSoft Technology Corporation (v11.5) toList >>