Hi Team, Can we have any functionalities available in QuickSight which help us to splitting the comma separated single column into multiple column. I read some answer on this topic in QuickSight so currently this functionalities are not available in QuickSight. Thanks & Regards Biswajit Dash

You can extract one from a calculated field. But you cannot add a row in quicksight. Calculated fields only create new columns. This can be accomplished via sql. For instance if you are using presto you can cast it to an array for all columns and then use the unnest function.

Converting a single comma separated row into multiple rows in QuickSight

Question & Answer

Max March 30, 2023, 8:38pm 2

Hey @Biswajit_1993

Does this help?

1 Like