0 Replies Latest reply on Sep 4, 2014 1:05 AM by Mengxi Liu

    Data flattening using Star Schema

    Mengxi Liu

      Hi all,

       

      We are recently investagating a data source flattening issue using star schema.

       

      As for the EXAMPLE DATASET illustrated below ,it there any straightforward way out using Tableau JOIN to pick up different items from one field into two so as to form the flattened Data Source during data connection stage (using fact table as the primary table and iClientID to recognise the earliest and latest segment).

      pic111.png

      So that we could get result as :

      by Earlist segment

       

      Acct Open
      Segment 13
      Segment 21

       

       

      by Latest segment

      Acct Open
      Segment 12
      Segment 22

       

      Have anyone got some experience or idea about that? Any suggestion would be fairly appreciated ! Cheers