AggText

The AggText function sends a request to execute an aggregate warehouse function that returns a text data type. This function is the aggregation version of CallText.

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

Syntax

AggText(function name, arguments...)

Function arguments:

function name (required) - an aggregate warehouse function to execute
arguments (required) - one or more arguments to pass to the warehouse function

📘
All arguments must meet the warehouse function’s input requirements. Unsupported arguments result in an invalid formula.

Example

A table contains a Customer Name column that generates each region's top five customers based on purchase activity. Using the AggText function, you can execute Snowflake's MIN function in a higher grouped level of the table to return the first customer according to alphabetical order.

AggText("MIN", [Customer Name])

Returns the first Customer Name value (based on alphabetical order) for each region in the Store Region column.