Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Sep 26, 2021

RELATED IDEAS

Make STRING_AGG available as aggregate function for In-Database connections

SAP HANA supports STRING_AGG function. https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/a924ee1e98ab435a874efa32e6f0ae14.html

Also SQL Server and Azure Synapse support STRING_AGG https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql

In Oracle there is LISTAGG. https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030

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.


concatenate-ava...
missing-concate...
concatenate-available-for-in-memory.png
Open full size
missing-concatenate-in-database-hana.png
Open full size
concatenate-available-for-in-memory.png missing-concatenate-in-database-hana.png
  • Attach files
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us