I have the following rows of data in viz "A":
Viz "B" has the distinct sub-set of data from viz "A" :
I'm wanting to do a LIKE type filter from "B" to "A" so that selecting AAA would return the following rows in viz "A":
Likewise, selecting BBB would return:
Does anyone know of an approach that will accomplish this? Using a Parameter is out as this is live data subject to changing from day to day.