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?