This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Counting comma seperated value as mutiple counts

Posted on 06-21-2024 10:11 AM
Doy
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have a column named "flavor" and it can have values such as:

- Dark Chocolate
- Oreo Birthday
- Dark Chocolate,Dark Chocolate,Dark Chocolate
- Dark Chocolate,Oreo Birthday

In the case where there are multiple flavors in 1 record, I would like to count them individually. Here is how my table shows these multiple flavors now:

Doy_0-1718989751316.png

Instead of that whole string being counted once, I would like for Dark Chocolate to be counted 3 times. Is this possible? Or do I have to make a separate table?

0 1 274
0 Likes
1 REPLY 1