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

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:

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?

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

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