Using Excel "Tables" as input in Alteryx

[vikasb512]

Are we able to use tables within excel as an input option within Alteryx? I only see the option to select ranges of cells within a sheet. If position of my tables within the excel sheet changes, I'll have to update alteryx everytime. Surely their is a way to use "Table1" as the input source?  

[Deano478]

@vikasb512 Just set the cell range to a big enough value so that no data is missed there no way to read in Table1 as a source

[alexnajm · Accepted solution]

@vikasb512 could a named range work for you? Otherwise go with @Deano478 's solution

[flying008]

Hi, @vikasb512 

You can define a big enough range for named range first, then select the named range as output scope.