5 Replies Latest reply on Aug 24, 2018 3:14 AM by soban ali

    Using Filter as a result of a subquery

    soban ali




      I have a requirement, I can explain it with a query, how can we use it in Tableau desktop.


      select medname from allmedicines where generic in

      (select generic from allmedicines where lower (medname) like '%&Medicine_name%');


      I want a filter of "medname" where my requirment is that when I write a "medname" in a filter it gives me all the "mednames" who have the same generic. is it possible in tableau?




      Soban Ali