Be sure to review our Idea Submission Guidelines for more information!
Currently on the input tool I can only specify if the first row contains data. It would be great if I could simply specify which row the data starts on, ie. row 4 or row 500, and then specify which row, if at all, contains the headers.
I know it is an old post, but I think a better solution would be to use the "Select Records" tool to choose which row to start from, then use the "Dynamic Rename" tool to take field names from first row of data for all the F.
@Fonsecathat is a really good option, and I wasn't even aware of that tool.
I won't bore you with all the particulars of my use case, but suffice it to say that in my case a major advantage of being able to just tell Alteryx where the headers/data begin is so it will correctly parse columns without additonal help from me.
I tried your solution, and in my case, I still have to follow it with the same parsing tools as before, all because Alteryx doesn't know where the headers are, and therefore thinks that the data is all in one column.
Alteryx, please, please listen to our pleas! We already have workarounds...what we'd like is SIMPLICITY. :-)
The ability to specify which line to start data import on is coming in 10.5 for CSV and TXT files. We'd love to hear if this covers the majority of use cases or if there are other file types where this would be useful.
@ARich THANK YOU!!!!
I personally think that it would be a nice feature to have for any kind of file, because the versatility of Alteryx is one of its greatest strengths. I believe this will solve my problem if it is incorporated into the "read file as" procedure. I'm reading in .prn files, but I'm asking Alteryx to treat them as .csv files.
At the very least, it might be helpful for many to be able to specify the starting row for .xls* files as well.
I would also like to see this with .xlsx files as well.
Is there a current solution for .xlsx files? The .xlsx tool does not have an option to specify a delimeter like the .csv tool does.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.