Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Sep 26, 2021

Make STRING_AGG available as aggregate function for In-Database connections

SAP HANA supports STRING_AGG function.

Also SQL Server and Azure Synapse support STRING_AGG

In Oracle there is LISTAGG.

This aggregate function is currently not available in Spotfire, see screenshot, but is very useful is lots of situations.

The Spotfire function Concatenate() should be mapped to this like it is available for In-Memory data.

  • Attach files