Using Excel "Tables" as input in Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
vikasb512
5 - Atom
‎01-08-2025
04:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Input
3 REPLIES 3
Deano478
12 - Quasar
‎01-08-2025
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
18 - Pollux
‎01-08-2025
05:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@vikasb512 could a named range work for you? Otherwise go with @Deano478 's solution
flying008
15 - Aurora
‎01-08-2025
05:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @vikasb512
You can define a big enough range for named range first, then select the named range as output scope.
