community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Removing the first line of every Sheet in Excel file while using Dynamic Input

Highlighted
Meteoroid

I want to import all of the Sheets in an Excel file using the Dynamic Input tool with Sheet Names.   The first line only has a merged cell in E5 and the column headers are consistent for all Sheets on Line 2.  Having an issue removing the first line from each Sheet before input.

Bolide

Hi @JayCaplan 

 

Have you tried configuring your dynamic input to "start input on line" 2? e.g.

 

Capture.PNG

 

Let me know if that works

Andy

Meteoroid

Hi Andy,   we tried that and it left off the first Sheet of the file.

Bolide

Hi @JayCaplan 

That's odd, it's working fine on mine. What configuration are you using? Feel free to attached a packaged version (with dummy data)

 

I just created an xlsx with 3 tabs, all of which had headers on line 2 (and merged cells in line 1).

There's 3 rows of data in each tab (rows 3-5) with headers in row 2, creating a table of 9 rows across the different tabs:

 

Dynamic2.PNG

So this is behaving as I'd expect. Like I say, feel free to send an packaged version over, I'm happy to take a look at your specific example. 

Andy

Labels