The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add Concat ability to In-DB Summarize Tool

Please create the ability to Concat a field in the In-DB Summarize Tool similar to the regular Summarize tool. This would enable much faster processing on concatenating fields using the database's processing power vs. the local machine.

1 Comment
SeanAdams
17 - Castor
17 - Castor

This is a good question - I believe that this kind of capability is supported in Microsoft SQL (TSQL) but not sure if this is ISO standard.

Reason for asking the ISO question is that if this is not an ISO standard (like sum; max; min) then it would be difficult to create an in-DB version because many DBs would not support it, or would implement this very differently.

 

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017

 

If you know of the ISO standard way to do this in SQL, that would really help to push your case for this one.