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

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

 

3 REPLIES 3
flying008
14 - Magnetar

Hi, @kathbanc 

 

flying008_0-1686110839068.png

 

kathbanc
8 - Asteroid

It it ok if you provide a file for this

flying008
14 - Magnetar

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.

Labels