We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start 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
Live Office Hours
Labels
Top Solution Authors
View All