Multiple excel sheets with different header at the end of every sheet

[SpiceNoodles]

Hi all, 

I am fairly new to Alteryx. I am attempting to cleanse my data after inputting multiple excel sheets. However, an issue I have are repeating headers/rows at the beginning of each excel sheet. I want headers to show only once. Why are these headers repeating?  Any suggestions on how would I remove these repeating headers and keep only one? 

[pedrodrfaria · Accepted solution]

Hi @SpiceNoodles 

They repeat themselves because we are loading many files at once. All the files have their respective headers.

Use the Filter tool to eliminate the extra rows that contain header information.

Or if you are outputting the name of the file as well, use the sample tool to remove the first row (which would contain the header).

Pedro.

[pedrodrfaria]

In this example I'm loading 3 files that contain the same information. I then use the filter to remove the rows that contain the column name, see below: