Is it possible to add a 'join' function as aggregate function in the SQL API for google sheets?

20 views
Skip to first unread message

Hernan Desio

unread,
May 6, 2016, 12:55:58 PM5/6/16
to Google Visualization API
I have an external sheet (that I cannot change) that contains rows with entries (like logs) for multiple projects and contracts.  I'm working on generating a Dashboard, and I would like to make a query that combines those logs into a single column (like the aggregated functions do):

For example 

|  A  |          ...         |     N       |
| PID |  many unused columns | Entry Logs  |
|  1  |      any data        | Log Text 1a |
|  4  |      any data        | Log Text 4a |
|  2  |      any data        | Log Text 2a |
|  1  |      any data        | Log Text 1b |
|  2  |      any data        | Log Text 2b |

I'm trying to get a query that gives me the following result

|  A  |                  N             |
| PID |         Entry Logs             |
|  1  |  Log Text 1a 'sep' Log Text 1b |
|  4  |  Log Text 4a                   |
|  2  |  Log Text 2a 'sep' Log Text 2b |


It will be really easy if the SQL API support the concatenation (or Join) as aggregated functions:

=query (A:N, "SELECT A, join('sep', N), GROUP BY A)

Is that something possible somehow else (without macros)?    If not, is it something that Google might consider?

Let me know
Reply all
Reply to author
Forward
0 new messages