2 Replies Latest reply on Sep 26, 2016 7:15 AM by Parteek Kumar

    How to filter one table based on output of other table

    Parteek Kumar

      Hello,

       

      How can we filter one table based on other. E.g.  I have one table Contacts which have 30,000 records. I have access to only few out of them say only 100 contacts. Now there is one more table Logs which have complete logs details of those contacts . Requirement is if I login to tableau I should be able to see logs of only 100 contacts i have access to.

       

      I am able to restrict the contacts using username () function . But my requirement is first filter the Contacts table so that I just get 100 records then i wanted to join to logs table so that it shows logs only for that 100 records.

       

      Thanks.