Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Remove First Row of Every Excel Worksheet

ecotton
7 - Meteor

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?

5 REPLIES 5
DavidP
17 - Castor
17 - Castor

Hi @ecotton 

 

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

DavidP
17 - Castor
17 - Castor

DavidP_0-1636125250309.png

 

ecotton
7 - Meteor

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

DavidP
17 - Castor
17 - Castor

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
7 - Meteor

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

Labels