How can i add new column with values after spliting string values from one column based on id in table report?

Question & Answer
, , ,
1

Hello Community,

I am trying to calculate a column with value of comma separated strings and get a new calculated column with all those values in separate rows. But I have not been able to get the answer to this query. I have tried to use split function for that as well but it also limits the result. How can I acheive this?

The example table is following where I want to create new field with concatenated_wrapup values:

Screenshot 2023-05-16 133755
Screenshot 2023-05-16 1337551354×219 26.5 KB

2

Hi @musama

In your concateneed_wrapups you then want to split it out? For instance you want to have multiple columns that will say each comma separate value?

3

I want to have multiple rows that will say each comma separate value in new calculated column. @Max

4

Hi @musama

You can’t do this in QuickSight. It will need to be done at the sql level.

A commonly used function for that is unnest.

1 Like