Convert Multi-Value Fields to String Fields in SAQL (Beta)
Querying multi-value fields presents a challenge: Only one item appears in query results. By converting each set of multiple values to a single, alphabetical, delimited string, a new SAQL function, mv_to_string(), shows all items in a multi-value field. The field remains multi-value in the dataset. This change applies to the query projection and results only.
Access Date Information With More Functions for Fiscal Year Data
From the team who brought you functions to retrieve the last day of a week, month, quarter, or year comes the same functionality for the first days. In addition to new first day functions, both first- and last- date functions are now available for fiscal year data. These functions work the same, but have the fiscal prefix.