This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm more used to Power Query in Excel so finding my way with Alteryx. I'm used to Excel offering me the actual table within an Excel worksheet rather than the whole sheet. As a result, a lot of my "standing data" has comments and other user-orientated "fluff" in the sheet (but OUTSIDE of the actual data table).
The size of the table may change over time so I do not want to incorporate an SQL statement to pick up on a worksheet range.
Is there a way of directing Alteryx to input data from a specific table name in Excel?
Thanks for posting. I'm happy with how to create Named Ranges in Excel but they're not the same as Tables in Excel. A table Excel can grow in size whereas a Named Range has to be redefined every time a row is added. I have a series of tables maintained manually and used as inputs to add context to my data.
Tables in Excel are pure tabulated data - the perfect feed into Alteryx; so there must be a way of naming the table in the SQL query rather than having to rely on Named Ranges? Maybe it's the same method / syntax? I just need someone to provide me with an example of the SQL query (my weakness...)
Currently, Alteryx has the ability to input sheets, named ranges and specific ranges; but due to the limitations of the Excel driver, not varying tables. An option would be to bring in the whole sheet and parse out the rows and columns that are not needed for your analysis.
If you would like more help on how to parse the data, please let me know and we can work offline.
Amy Davies Community Moderator and Customer Support Engineer Alteryx