In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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