This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
I think it looks good! However I have even more complex situation. Every month I add a new report to a folder
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?
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?
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.