how to filter by a list of words in Google Data Studio report?

Question

I would like to know how to how to filter by a list of words in a Google Data Studio report?

E.g. given a table-like Google Data Studio object, I'd like to have a list of, say, 200 entries, such as below:

foo
bar
...
baz

That I can either copy+paste or supply as an input file to one of the Google Data Studio controls, and then filter the entries in the table to only those intersecting with the list.

This can be done one-by-one with shorter lists (I wouldn't want to do it with 200 to them manually), using for example the Control > Drop-down list, but I can't copy+paste a long list from e.g. a spreadsheet table into the text field of a Drop-down list control.

Any ideas?

question from:https://stackoverflow.com/questions/66063758/how-to-filter-by-a-list-of-words-in-google-data-studio-report

Answer 1

Waitting for answers