Directory and Dynamic tool how to import from a specific row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lumjingbki
8 - Asteroid
‎10-19-2023
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Developer
3 REPLIES 3
17 - Castor
‎10-19-2023
06:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Why can't you configure your Dynamic Input to read from Row 4?
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
18 - Pollux
‎10-19-2023
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Cmacp433
7 - Meteor
‎04-03-2024
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
