3 Replies Latest reply on Feb 17, 2017 10:23 AM by Tom W

    Flattening data to single row when record contains multiple values for a field

    Chris Horner

      I have attached an example Database extract where one record has multiple values for a field.

       

      My goal is to have tableau export a crosstab excel file that renders the information in a report like this:

       

      Instead tableau is rendering a crosstab excel like this:

       

      Basically I want to flatten this to a single like and remove nulls.  Would anyone have a recommendation?  I've tried calculated fields but I must not be using the right calculations.