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).


      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