1 Reply Latest reply on Nov 15, 2018 7:40 PM by swaroop.gantela

    Perform a LIKE (Contains) Filter Action between two vizzes with different data sources

    Chad Tucker

      HI All,

       

      I have the following rows of data in viz "A":

      AAA;BBB;CCC

      AAA;AAA

      DDD:AAA;AAA

      FFF;

       

      Viz "B" has the distinct sub-set of data from viz "A" :

      AAA

      BBB

      CCC

      DDD

      FFF

       

      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":

      AAA;BBB;CCC

      AAA;AAA

      DDD:AAA;AAA

       

      Likewise, selecting BBB would return:

      AAA;BBB;CCC

       

      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.

       

      Thanks