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.
Test - this sheet has the headers and data
Test(1) - no headers, just data
Test(2) - no headers, just data