Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 Discussions

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

XLS FILE Importing of data starts with line 16

kathbanc
8 - Asteroid
‎06-06-2023 08:43 PM

Hi! 

 

We have XLS format file, and the line starts with line 16. How can I do that? Please take note that if file is XLS ( 97-2003)  . Start Data Import line is not possible. 

 

kathbanc_0-1686109136477.png

 

Reply
0 Likes
3 REPLIES 3
flying008
15 - Aurora
‎06-06-2023 09:07 PM

Hi, @kathbanc 

 

flying008_0-1686110839068.png

 

Reply
0 Likes
kathbanc
8 - Asteroid
‎06-06-2023 09:30 PM

It it ok if you provide a file for this

Reply
0 Likes
flying008
15 - Aurora
‎06-06-2023 10:39 PM

Hi, @kathbanc 

 

For your .xls file:

1- Input Data : select the option of 6- First Row Contains Data.

2- Select Records : 16+

3- Dynamic Rename: Take Field Names from First Row of Data.

Reply
0 Likes
view community events calendar
designer new user guide
Labels