Transform a string to a list

[Baoduong]

Use case, I have dataset (which I don’t have the ownership, can use-only):
Branch ID | store IDs
Each brand id goes with a list of store ids in the format of a string, separated by ‘,’
Example:
B001 | S001,S002,S003
B002 | S004, S005

I want to create a 2 tables, one is for list of branches. Click on each breach, the 2nd table will show all store IDs with it.
How could I do it?

[Deep]

Hello Bao,

First of all Welcome to the Quicksight Community.

Please refer to this old post, may be this is similar to what you are looking for.

Filter on array type of data

Hi team, I have one column ABC_Col. The data type is string, but data is in array form. [image] I want to have filter on this column through control & parameter. In control filter, we want multi select list. The list would have unique values like, a, b, c. Based on how many value user selects, we want to filter out rows. For example, if user selects “a” & “b”, then it should return only 1 & 3 rows. Example 2: if user selects “c”, then it should return only 1, 2 & 3 rows. How can I achieve …

Hope this helps.
cheers,
Deep

[Baoduong]

Hi, Thanks for your help. However, your post was about the parameter and filter. My request is to break the string to a list and show it in the table (in order to do the action on that table).

[Koushik_Muthanna]

@Baoduong ,

what is expected end-result ?

Kind regards,
Koushik