Is it possble to use something similiar to string_split in LookML to get unique value for my filters?
I have a table that looks like this:
id | Column1 | Column2 |
12 | dog, cat | apple, pear |
23 | dog | cherry, apple |
34 | cat, deer | cherry |
I want to create filter using column1 and column2, but i want this filter to have unique values. For example, the filter for column1 should contain “dog; cat; deer” and no combinations.