2 Replies Latest reply on Aug 6, 2018 6:21 AM by meenu choudhary

    Is there a way to replicate excel index function in tableau?

    chandrakanth k

      Hello All,

       

      In my data source I have two excel work books

       

      1. LDB V3 and 2. Calendar. I blended both files in tableau using System as key column.

       

      In LDB V3 I have due date and based on due date I need to find next available date in calendar and call it pay date.

       

      I was able to do this in excel using Index function. How do I replicate this in tableau?

       

      For line one where net due date is Jul 25 2018, I need to get first available date from "Calendar" which is 7/30/2018.

      If system is SAP and payment vendor is D and payment schedule is Rglr I need to refer to column "Biweekly - D" in calendar to arrive pay date 7/30/2018.

      In my secondary source I have 5 columns for

       

      Need help

      Regards,

      Chandrakanth.K