Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Using Excel "Tables" as input in Alteryx

vikasb512
5 - Atom

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?  

3 REPLIES 3
Deano478
12 - Quasar

@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
18 - Pollux
18 - Pollux

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

Using Excel Tables as input in Alteryx.png

flying008
15 - Aurora

Hi, @vikasb512 

 

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

Labels
Top Solution Authors