Using Excel "Tables" as input in Alteryx

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?

Input

Accepted answers

alexnajm

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

Using Excel Tables as input in Alteryx.png

All comments

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

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

Using Excel Tables as input in Alteryx.png

flying008

Hi, @vikasb512

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703