Split aggregation for a filter in LookML

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.

0 0 81
0 REPLIES 0
Top Labels in this Space
Top Solution Authors