5 Replies Latest reply on Dec 13, 2017 8:15 AM by Jon Baker

    Check if value from column in datasource A exists in same column in datasource B

    Kerith Gaines

      Hi there! I'm stumped on how to write this calculation in Tableau (vs 9.1).

       

      My workbook is connecting to 2 different datasources (both datasources are stored on our Tableau Server). Each datasource shares a column "Part Number."

       

      I want my calculation to check if the value from "Part Number" in Datasource A can be found in the "Part Number" column in Datasource B. If it can be found, I want it to return a value of "Yes" otherwise I want it to say "No."

       

      I'm sure this is something simple - but I've been staring at it a few hours and all my IF/Else attempts are not working, lol. I appreciate the help!