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