1 Reply Latest reply on Sep 6, 2018 9:59 PM by Ken Flerlage

    Handling two separate tables in one sheet in excel into Tableau Prep

    Ed Scarberry

      I have a sheet that has two separate tables.  One set has energy and the other regulatory.  Based on the titles of the table I need to separate them.  So from A1 to XX that is Energy.  From where the title regulatory starts and on to the end that will be regulatory.  So not only do I first separate the tables at first I will have a new field called type and that will be used to show which set of data is regulatory and which is energy.  Then I can join it back together.

       

      I cannot figure out how to accomplish that.