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.
on 05-08-201307:50 AM - edited on 03-11-201909:53 AM by SydneyF
Alteryx allows you to input a selected range of values from your Excel spreadsheet. This can be handy when working with large Excel files where you only need a small subset of data, thus providing you an opportunity to optimize the processing time of your module.
In Alteryx versions prior to 18.1, the following example illustrates how to do this.
In this example our data starts in row 5 and column B and ends in row 7 and column D.
Begin by bringing the Input tool into your module, then browse to the particular sheet in your Excel file that you wish to pull data from. It will look like the following image. Notice that Option #3, Table or Query, points to ‘Sheet1$’, we will modify this to point to our data range.
To edit the Table or Query, click on the button with three dots (…) on the right side of Option #3.
Next, click the SQL Editor button and change the range from
Sheet1$ to Sheet1$B5Robot Very Happy7
Click OK. Now click on the Update Sample link In the Input Tool properties window to see the new range.