Alteryx Designer Desktop Discussions

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

Directory and Dynamic tool how to import from a specific row

lumjingbki
8 - Asteroid

Hi have a excel file and I am reading the file using Directory and Dynamic tool. I want to read it starting from row 4 ignoring the top rows of merged cells and empty rows. can anyone help how go about reading from row 4. Please find attached a sample file

 

 

3 REPLIES 3
caltang
17 - Castor
17 - Castor

Why can't you configure your Dynamic Input to read from Row 4?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
alexnajm
18 - Pollux
18 - Pollux

When you set up the Dynamic Input tool, you should be able to specify Option #7 - Start Data Import on Line X. It likely starts in 1 for you, so I'd change this to 4!Directory and Dynamic tool how to import from a specific row.PNG

Cmacp433
7 - Meteor

Hopefully a step by step here for future reference:

 

  1. Click the dynamic import
  2. Select edit
  3. In the dialogue box, scroll down in the options window to reveal line 7
  4. Update to the row # you want to import
 
 

 

 

Labels
Top Solution Authors