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)

Add comment