Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Does Quicksight support a GROUP_CONCAT function?

0

Does Quicksight support a GROUP_CONCAT function? I'm wanting to transform data from a single column across multiple rows into a single row that is comma separated.

Topics
Analytics
Tags
Amazon Quick Sight
Language
English

asked 2 years ago494 views

1 Answer
2
Accepted Answer

Quicksight doesn't have a built in group_concat function.

If you are using SQL, try:

SELECT Category, GROUP_CONCAT(Value SEPARATOR ',') AS ConcatenatedValues
FROM your_table
GROUP BY Category

answered 2 years ago

EXPERT

reviewed 2 years ago

  • Josh
    2 years ago

    Thanks I don't have much experience with SQL but was able to figure it out from this.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content