community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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
Nebula
Nebula

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.