Filtering Views based on runtime condition value and joining together

done
low_priority
reply

(Umesh) #1

Hi,

How can I filter two LookML views separately based on runtime values for filter condition values and than join them.

For example: I have two views as defined below:
LookML View A : attribute 1 … 10
LookML View B: attribute 10 … 20

View A to be filtered on

  • attribute 3 based on value provided at runtime

View B to be filtered on

  • attribute 14 based on value provided at runtime
  • And attribute 17 based on value provided at runtime

Join Filtered LookML View A and Filtered LookML View B
ON A.attribute10 = B.attribute10

Thanks,
Umesh


(Umesh) #2

LookerFilterViewsAndJoin


(Umesh) #3

@izzy: Any insights from your side on this issue will be much appreciated.


(Ian) #4

Use a derived table and feed in the filter values using: https://docs.looker.com/data-modeling/learning-lookml/templated-filters