7 Replies Latest reply on Aug 20, 2018 7:10 PM by meenu choudhary

    Excel multiple tab union - headers on first sheet only

    Gregory Wire

      Hi All,

       

      I have a data output into excel that I am trying to bring into Tableau.  B/c the data exceeds the excel row limit when writing to excel it writes onto multiple worksheets.  The first sheet has the headers for the report.  The subsequent have data only and no headers.  I used union with wildcard because the output number of worksheets can change.  Any way to union that data with the first sheet headers and other sheet's data without having to manually add headers?  Source program can not add headers to each sheet. 

       

      Thanks!

       

      Example:

      Worksheets:

       

      Test - this sheet has the headers and data

      Test(1) - no headers, just data

      Test(2) - no headers, just data

      etc...