1 Reply Latest reply on Oct 7, 2019 12:55 PM by Jim Dehner

    Vlookup in Tableau Online

    Namit Singh

      I have 2 data sources. One is a database and the other is a local Excel file.

       

      The primary key in the database is Invoice Number and Product Code in Excel file. One invoice can have multiple product codes. So, I have linked both the sources based on the Product Code. The excel file has say 3 columns: Product Code, Column A, and Column B. I want to create 2 calculated fields in the database source that gets the values from Column A and Column B in the Excel file. Basically the vlookup function used in Excel.

       

      Any help on this is appreciated.

       

      P.S: I cannot attach the workbook because of sensitive data.