Alteryx Designer Desktop Discussions

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

Delete First Row (Dynamic Rename)

AW25
7 - Meteor

Hello! I'm trying to delete the first row of data in my output. All of the posts I've come across seem to suggest using the Dynamic Rename tool and setting it to 'Take Field Names from First Row of Data' and that does get rid of the original first row but it also changes the data in the new first row. What am I missing here?

 

Original

2018-07-25 Original.png

 

Dynamic Rename

2018-07-25 Post.png

2 REPLIES 2
neilgallen
12 - Quasar

@AW25 You could use the "Select Records" tool and set the range to "2+." 

 

Alternatively, the sample tool would allow you to skip a set number of rows. Set this to 1. This assumes you want to keep the field names as their original set but not include the first row of data.

AW25
7 - Meteor

Thanks Neil! I had to set it to '0+' as '2+' ended up dropping the header and first 2 rows of data but your solution was perfect, much appreciated!

Labels