This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I added an Input Data item to my workflow to read in an xls file and want to skip the first and third rows, with the header in the second row. So to skip the first row, I was looking for the option/setting within Input Data for "Start Data Import on Line #" but I can't see it. This is what I see:
I was going off this forum post since it's relatively new. Where can I find the setting?
If it matters, I'm running Alteryx Non-Admin Designer Version 2018.4.5.55178
Perfect, that works! It doesn't seem as if Alteryx knows when to stop reading a file - I have just 20 records in my file so I had to make it 2-20 (changed to file to xlsx). Alteryx seems to think there's a lot more so the output of a conditional if statement goes on forever. Do I have to specify the row number when Alteryx should stop reading?
When more rows are read in by Alteryx in an excel file that usually suggests that there is some kind of unusual excel formatting causing it to look like there is data further down the spreadsheet.
Your method will definitely work if you know there will never be more than 20 records in the file. If there could be, I would recommend using a Filter and picking a field that you know will always have data in it, and doing something like:
That way you can handle a dynamic number of records while still only keeping valid data.