Google Data Studio - Separating values within string

user_2749879 0
Viewed 7369

I have a Google Spreadsheet linked to Data Studio and one of the columns has a comma separated list of values (example: book,car,house)

Within Data Studio you can output that row however I'd like to be able to split each value to be individually searchable/filter.

I've not come across anything that seems to make this possible without having to modify the spreadsheet which I'd prefer not to do. Is there any way within Data Studio to make this possible?

google-data-studio google-sheets
1 Answers

You can create your own customized Community Connector that will do this. In the connector code, this field will have to be parsed into separate fields. You can use split() to do that.

user_40240720
Related