7 Replies Latest reply on Aug 20, 2018 12:19 PM by Jim Dehner

    Look up and Fill empty Cell Values based on another column

    Myni V

      I have my data in below format.

       

        

      DepartmentProj IDAmountType
      sales1100Target
      sales2200Target
      HR20300Target
      IT310Target
      110actual
      215actual
      220actual
      2010actual
      310actual
      35actual
      34actual

       

      When the type is actual department is empty. But I want the department field to be populated for all the actual type rows based on the Project ID like below.  See for the project Id with type Target and get its Department and fill the same department for all the actual type records. How can I do this in Tableau?

        

      DepartmentProj IDAmountType
      sales1100Target
      sales2200Target
      HR20300Target
      IT310Target
      sales110actual
      sales215actual
      sales220actual
      HR2010actual
      IT310actual
      IT35actual
      IT34actual