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.4) | toList >> |