Hi -
I have about 20 workbooks and some of them start on different rows. Is there an easy way to start the data at the row that says ACF2?
Thanks!
Solved! Go to Solution.
Hi @jenner85
My approach would be to input the data, but don't use the headers. So it would import your files with a generic F1, F2, F3, etc. Just make sure to click the First Row Contains Data button on the input tool. From there, you can apply a couple different tools to determine the first row of data, append that row number back to your original data set, filter all records out before that row, and then use a Dynamic Rename to grab the headers.
Input #1:
Output #1:
Input #2:
Output #2:
Attached is a sample workflow that you can modify as needed.
If this solves the problem please mark answer as correct, if not let me know!
Cheers!
Phil
@Maskell_Rascal Hi - thanks for the response. Would this work if there was also data in the top row? I need it to ignore row 1 and 2 -
Hey @jenner85 - If you need to always skip the first two lines of the file, you can do that through the Input Tool. Just select that you want to start your data import on either line 2 or 3 depending on how your files look.
Here is my file for Book1 before importing to Alteryx:
Here is the Input Tool setup:
Now it skips those first couple lines, and the rest of the workflow will find the first row of data and return it with new headers.