Developing Apama Applications > Dashboard Function Reference > Tabular Functions > First Table Rows
First Table Rows
Returns a table containing one of the following:
*First n rows of a specified table, for a specified number, n.
*First n rows for each unique combination of values in a specified set of columns in a specified table, for a specified number, n.
Arguments
This function has the following arguments:
*Table: Table some of whose rows are to be returned.
*Index Column Names: Text string that specifies the column or columns to be used to form indexes. Separate column names with a semicolon. If this argument is not supplied, the function returns the first Number of Rows of Table. If this argument is supplied, the function forms indexes by concatenating the values contained in each index column, and returns Number of Rows rows for each index.
*Number of Rows: Numerical value that specifies the number rows to be returned, or the number of rows with each index value to be returned.
The function returns a table.
Copyright © 2013 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.