The above suggestion is great and probably will work for you, but one other:
I am guessing you are reading from Excel. Since its not really a database format it has issues like this. You can create a named range in Excel that will then be available as a separate table. You can also specify a specifc range in Alteryx.
From the Alteryx help:
Specify Data Range of Input File: Identify the cells that contain the data to read into the module
Example: S:\temp\temp.xls|Sheet1$a2:b4 where A2 is the beginning of the data and B4 is the end. Keep in mind that Alteryx will handle A2 as a header field, as well as all of the columns in row A.
Another way you can do this is to create a named range in Excel and then that range will be an option when you browse to it in Alteryx.
|