SOLVED
Create field names from row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
robertcox87
7 - Meteor
‎09-20-2021
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am using Alteryx to read a sheet from an Excel file and the column headers are on the 5th row of the spreadsheet. Is there a way to create column headers from this row? Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
3 REPLIES 3
markcurry
12 - Quasar
‎09-20-2021
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @robertcox87
You can either change your Input tool for Excel file to set 'Start Data on Import Line' = 5, order you can use the Dynamic Rename tool to take headers from the first line of data. See attached sample.
mihaicom20
8 - Asteroid
‎09-20-2021
08:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
On Input Date Tool you have the option to start importing the data from a specific row.
I hope this helps you.
Maskell_Rascal
13 - Pulsar
‎09-20-2021
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
