VALUETABLE

This function returns a value table that contains the number of columns that matches the number of function parameters. Detailed records are produced from data sets that are required for getting all the fields used in the function parameter expressions. If an expression contains a ValueTable function, this expression is considered an aggregate expression.

The function can have one or several parameters of arbitrary types. Each parameter can be followed by an optional AS keyword and a name to be assigned to a value table column.

ValueTable(Distinct Products, ProductCharacteristic AS Characteristic)

Next page: GROUPPROCESSING

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.