Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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.

2 Comments
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.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes