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
by Latest segment
Have anyone got some experience or idea about that? Any suggestion would be fairly appreciated ! Cheers