In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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