I have a Tableau chart reading from a shared Excel file. Now the Excel file owner has added a few header lines into the file that causes Tableau to not recognise the column headers. I have no control on the Excel (i.e. cannot change the content), and my chart is supposed to read from that file "live" (i.e. I can't maintain a separate "cleaned" copy).
Is there a way to make Tableau skip the first few rows when reading from Excel?
Version 9 is due to ship soon, and has features to help cases like this.