Feature Request: GROUP_CONCAT

[Jaka Jancar]

An aggregate function that concatenates the values in the group

[Jaka Jancar]

Let me explain why we would need this:

We have a pageviews table with columns: (timestamp, visit, page). We
would like to generate report on the most common "user flows", based
on the first 4 pages, to return rows like ("home, gallery, home,
news", 50000), e.g. using:

SELECT GROUP_CONCAT(page ORDER BY timestamp LIMIT 4) flow, COUNT(*)
FROM [table] GROUP BY flow;

Is there another way of achieving this with BigQuery?

[Jaka Jancar]

Hi!

Any update on this request or suggestion about how we could work
around this?

Best,
Jaka