community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Skip first rows excel and read headers

Asteroid

Hello, 

 

I am using Salesforce data and when I export the data to excel it has first rows showing which filters were used and some basic information (who generated the report, time and name of the person). Data headers are only on 12 row and data is starting from row 13 of excel file. I would like to read this data and perform calculations in Alteryx, but I would like to skip first rows and read data starting from row 12. Alteryx flow should also recognize that header are on raw 12. Do you have any suggestions how to solve it?

 example.PNG

Quasar

Hi

 

You can use the Input Tool's settings to skip the first rows. Will this work for you?

 

InputToolSkipFirstRows.png

Asteroid

Hi, 

 

I think it looks good! However I have even more complex situation. Every month I add a new report to a folder 

2018-07 Orders.xlsx

2018-06 Orders.xlsx

2018-05 Orders.xlsx

 

Then with Alteryx I want to read those reports together. I build a flow for these. However the problem is now that I have a long list of these values and these filter rows are appearing in the middle of the list. I wonder how I could remove fist these filter rows and then combine the data? 

 

example 2.PNG

-Anastasiia 

Highlighted
Quasar

There is the same option with the Dynamic Input tool. When you choose the Input Data Source Template, use the same Start Data Import on Line = 12.

Asteroid

example 3.PNG

 

I am using Query in Dynamic input. I am not sure if I can do the same as you suggested in this case 

Quasar

Maybe I'm not understanding. If you're reading a series of Excel files, then you have the same options at the Input Tool for the Input Data Source Template. Did you mean you are directly querying the database?

 

InputToolSkipFirstRows.png

Asteroid

Hi, 

 

This what I was just looking for! Big thanks for this solution! 

Meteor

Has this option changed in recent versions? I do not see that option in my input tools.

 

Thanks,

Joe

 

Community Operations Manager
Community Operations Manager

@Joe_McCoy,

 

That option is only available in xlsx and not xls. You can use the "first row contains data" to push your headers into the first row. Then use a combination of a Record ID tool and a Sample or Filter tool to remove the rows you don't want. Then use a Dynamic Rename tool to take the data from the first row to create headers.

 

DanM

Labels