Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Skip first rows excel and read headers

Anastasiia
8 - 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

10 REPLIES 10
cpenasie
5 - Atom

If you have the specific range into your Excel, you could set the range into 3rd option of Input Data. For instance, if you want skip only first row and you know the las column then you should write "A2:BH". 

cpenasie_0-1614105143970.png

 

Labels