1 Reply Latest reply on Apr 5, 2018 4:47 PM by Amber Loranger

    Can Tableau Build a Data Source Relationship to look at two key fields

    Andrew Payze

      Hi,

       

      We have a situation where we need to build a relationship between two Data Sources (DS), where there are 2 keys on the 2nd source to look at.  We cannot create the correct calculation when building the relationship in the Data Source.  Does anyone have any ideas on how to do this please?

       

      Here is what we are looking to do....   DS-A ID field value can be found in either the DS-B ID1 or DS-B ID2.  If it finds a match in ID1 that is OK, if not then look at ID2

       

      DS-A->ID = (DS-B->ID1 OR DS-B->ID2)

       

      Regards

      Andrew