2 Replies Latest reply on Aug 17, 2017 1:28 AM by Tricia O'Keeffe

    Calculated Field - SQL Syntax

    Tricia O'Keeffe

      Hi all,

      I'm fairly new to Tableau and would value your help please:


      I have a table with the following example data:


      Action_ID   Customer_ID

      1                3321

      5                3321

      1                4856



      I want to select records where Action_ID = 1, but not if the associated Customer_ID also has a record with Action_ID = 5.



      In this example above, I only want Customer_ID 4856 returned.


      If anyone can help me with the correct syntax that would be much appreciated.

      many thanks Tricia