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?
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.
Hope this helps.
cheers,
Deep
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).
The expected result is 2 tables:
Branch
B001
B002
Stores
By clicking B001 in table [1. Branch], the data in table [2. Stores] will show:
S001
S002
S003
Hi @Baoduong,
Quick Sight does not have a great way of completing this out of the box. From the dataprep view, you could use the split function but since you do not have access to that, there’s only one other way you could sort of complete this.
You could use substring to essentially create a new field for each group of stores. For instance, ‘Store 1 per Branch ID’ and then you can use substring to pull out the first store option for each branch ID and then continue to repeat process for as many stores as the max per branch ID.
There’s no great way to list them descending within one column though.
Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Baoduong,
Since we have not heard back any further, I will go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!