1 Reply Latest reply on Jun 20, 2018 1:28 PM by Yuriy Fal

    SLOWLY CHANGING DIMESION IN TABLEAU (HISTORYCAL DATA)

    Dilyana Suleymanova

      Hi there,

      I have two tables:

       

      Table 1

       

      DepartmentNameEmployeeValidFromValidTo
      AndroidAppsDavid01.01.201810.01.2018
      AndroidAppsPeter01.01.201831.12.2018
      ProductDevelopmentDavid11.01.201831.12.2018

       

      Table 2

       

      EmployeeUmsatzDatum
      David10002.01.2018
      David5003.01.2018
      David30012.01.2018

       

       

      I want to join both in Tableau and get this result

       

        

      ATTENTION: There are NO values by David by ProductDevelopment!

       

      when I use inner join in tableau, I get this result:

       

       

      ATTENTION: There are values by David by ProductDevelopment!

       

      How can I fix it?