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.
Solved! Go to Solution.
Hi @jaycaplan
Have you tried configuring your dynamic input to "start input on line" 2? e.g.
Let me know if that works
Andy
Hi Andy, we tried that and it left off the first Sheet of the file.
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:
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
This was actually helpful to figure out why Line 1 in my output was deleting. I needed to check the "First Row Contains Data" box.