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

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.