Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Specify the row where data starts

Status: Implemented Submitted by on ‎05-16-2014 03:32 PM
16 Comments (16 New)

Currently on the input tool I can only specify if the first row contains data.  It would be great if I could simply specify which row the data starts on, ie. row 4 or row 500, and then specify which row, if at all, contains the headers.

See more ideas labeled with:
16 Comments
cbridges
11 - Bolide
‎05-03-2016 03:53 PM

@ARich I agree with @cpbrehmer and @bpschoon that specifying the row for .xlsx files would be helpful as well.

0 Likes
ARich
Alteryx Alumni (Retired)
‎05-04-2016 12:44 PM

Thanks for all of the feedback! I have added "Specify Which Row to Start Data Import for .xlsx Files" to the backlog and we should be able to get that in for 11.0!

 

Best,

Alex

0 Likes
ARich
Alteryx Alumni (Retired)
‎06-14-2016 01:38 PM
Status changed to: Implemented
 
0 Likes
TaraM
Alteryx Alumni (Retired)
‎06-15-2016 10:14 AM
Status changed to: Implemented
 
0 Likes
MizunashiSinayu
8 - Asteroid
‎07-13-2016 01:46 AM

For the while, use filter skip 1st N records :D

 

You can rename the fields using multiple methods one of them would be select tool :D

0 Likes
PedroPerdomo
7 - Meteor
‎09-01-2021 06:39 AM

Hi,

What can I do when my data (or data that I need) start in cell "A3" and I want to used the headers from cell "A4" down.

 

any suggestion?

0 Likes
Labels