1 Reply Latest reply on Nov 21, 2018 10:33 AM by patrick.byrne.0

    Merging two worksheets based on calculated filed

    Madhu k

      Hello Everyone,

       

      i am trying to merge two worksheets in tableau. Need help

       

      sheet1: created a table and ranked based on increase in sales

      sheet2; created a table and ranked based on decrease in sales

       

      now, i need to match(Basically, like excel vlookup, rank 1 from sheet one should match with rank 1 of sheet 2 with all other columns) ranks. I tried using Custom SQL and blending on calculated field but solution is not there. Please help.