Remove First Row of Every Excel Worksheet

[ecotton]

I have an issues where I am using the directory to pull all excel sheets in a certain folder and then a macro to pull them into Alteryx. Well every Excel sheet has data on the first row that I do not want. I want the second row to be the column titles (which I know can be done with a Dynamic Rename) but I need to get rid of all the first rows to start. I know I could filter but it is causing these first rows of data to mark them as column titles which I do not want. Each month I am going to add a new Excel sheet and that will add a new column title. Any suggestions for deleting the first row of data on each excel sheet before the macro?

[DavidP]

Hi @ecotton 

You can use the Sample tool to skip the 1sr row

[DavidP]

[ecotton]

If I put it right after the directory, then it just removes one of my Excel sheets on the macro input.

[DavidP · Accepted solution]

You need to do it inside the macro.

You can also set the  Input data tool in the macro to start reading on line 2, then you don't need the sample tool

[ecotton]

Wow, didn't even think of that! This is perfect, thank you 🙂