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
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/95a4411a-b7f9-4e46-93ad-d41c9000bfc2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
