3 Replies Latest reply on Nov 13, 2016 6:39 PM by lei.chen.0

    Vlookup using same table array in tableau

    Harsha R M

      Guys - I am definitely going crazy! I cannot do simple excel functions in Tableau. Please help !

       

      I have data that looks like this.,

       

      Tab1:

         

      Product nameBase product nameProduct family seriesBase product family series
      AppleCarrotsFruitVeggies
      PearBananaFruitFruit
      GrapesAppleFruitFruit

       

      tab2

         

       

      ProductFamily
      AppleFruit
      PearFruit
      CarrotsVeggies
      GrapesFruit
      BananaFruit

       

      In tab 1, I am using vlookup for columns "product family series" and "base product family series", and I am getting my values form tab2.

      Now, In tableau for implementing this I did a edit relationship, and I created a custom relationship for joining two data sources. I did tab1.product name = tab2.product. Which is fine, I got all values for "product family series" column. But now I need to use tab2 for fetching base product family series column also. But when I change the relationship to tab1.base product name = tab2.product, my first relationship is overwritten.

       

      How do I do this? Attached is excel