1 Reply Latest reply on Mar 15, 2018 5:18 PM by swaroop.gantela

    Use multiple fields to link data together

    Juan Daza

      Hi All!

       

      I have two different datasets that are related via two different fields. I need to link them both based on either field. This means that I would first try and link them on Field A and if that fails, I would require it to be linked via Field B.

       

      In Excel I would do something like =IFERROR(VLOOKUP(FIELDA,ARRAY1,1,0),VLOOKUP(FIELDB,ARRAY2,1,0))

       

      I have tried to create a relationship using FIELD A but is there a way to tell Tableau to also look in FIELD B whenever FIELD A fails to find a value?

       

      Thanks a lot!