Delete First Row (Dynamic Rename)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Dynamic Rename
Solved! Go to Solution.
- Labels:
- Developer Tools
- Dynamic Processing
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
