User Guide > Creating and Querying Tables > Table Functions
  

Table Functions
The table functions include:
*BUILD_TABLE—Creates a new table from numeric or string vectors (one-dimensional arrays) of equal length.
*QUERY_TABLE—Lets you subset, rearrange, group, and sort table data. This function returns a new table containing the query results.
*UNIQUE—Removes duplicate elements from any vector (one-dimensional array).
*GROUP_BY—Performs summary (aggregate) functions to groups of rows in a PV‑WAVE table variable.
*ORDER_BY—Sorts the rows in a PV‑WAVE table variable to create a new table.

Version 2017.0
Copyright © 2017, Rogue Wave Software, Inc. All Rights Reserved.