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
AnalyticsBusiness ApplicationsMachine Learning & AI
Tags
Amazon Quick Sight
Language
English
asked a year ago280 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 a year ago
EXPERT
reviewed a year ago
  • Josh
    a year 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