Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find row where data starts

jenner85
8 - Asteroid

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?

 

jenner85_0-1624647052265.png

jenner85_1-1624647074281.png

 

Thanks!

3 REPLIES 3
Maskell_Rascal
13 - Pulsar

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. 

 

Maskell_Rascal_4-1624649324885.png

 

 

Input #1:

Maskell_Rascal_0-1624649247274.png

 

Output #1:

Maskell_Rascal_1-1624649267910.png

 

Input #2:

Maskell_Rascal_2-1624649288825.png

 

Output #2:

 

Maskell_Rascal_3-1624649307519.png

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

 

jenner85
8 - Asteroid

@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 - 

jenner85_0-1624882657243.png

 

 

jenner85_0-1624880983438.png

 

Maskell_Rascal
13 - Pulsar

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:

Maskell_Rascal_0-1624888464079.png

 

Here is the Input Tool setup:

Maskell_Rascal_1-1624888509186.png

 

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. 

 

 

 

Labels
Top Solution Authors