Add Concat ability to In-DB Summarize Tool

[OneandOnly13]

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.

[SeanAdams]

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.