Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
This article explains how to run workflows referencing excel files that are open by another user. This can be a requirement where multiple users are using the same file to update information
View full article
Adding or overwriting a worksheet in a workbook that contains a pivot table, corrupts the file and an attempt to repair the excel sheet removes the pivot.
View full article
When using a python tool with pandas package, xlrd is unable to read .xlsx files, only .xls.
View full article
Error: "Windows Security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver" when loading an Excel .xls file
View full article
This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.
View full article
When publishing a workflow to Gallery or Scheduler (Designer + Desktop Automation) or when packaging a workflow for export, checking the boxes for what to include and what to exclude seems to work inconsistently as of Designer 2020.2. The workaround will tide you over until you can upgrade to 2021.2.
View full article
You may already know how to use the MIN() and MAX() functions to find the smallest and largest values in a list. But what if you needed the second smallest number or 3rd largest number in the list? Excel has a function for this. Using the =SMALL function, you would specify the data range followed by 'x' smallest number you want to find.
View full article
To find the full path and filename of a saved file in Excel, you use the =CELL function.
View full article
How To: Read XLS files – with several tabs that contain diacritics Information
View full article
Sometimes we just rely on tools because we know how to use them. Case in point Excel. Excel is great because it is a program that most people know how to use and you can be sure that if you send someone an Excel file, they can read it.
View full article
This issue appears when an App writes to an Excel document. When the results are displayed and the Excel document opened, it will show as empty. As soon as the Excel document is closed, an Unhandled exception error will display, and the App cannot be closed.
View full article
Ladies and Gentleman, I introduce to you the beautiful functionality of the Run Command Tool. With this trick, you never have to go into the directory to manually open the saved file again.
View full article
Ever have to output tables of differeing schemas to the same Excel workbook? Ever need to output to different tabs? This article covers your bases with the cunning use of Reporting tools! Also included are links to other helpful "outputting to Excel" Knowledgebase Articles.
View full article
Have you ever tried writing to multiple tabs within the same workflow and have received an error? This article is for you!
View full article
When importing a .xls file using the Input tool, Alteryx produces NULL values for specific cells, why does this happen?
View full article
Excel has a new function called XLOOKUP. It's still in beta so you may not have access to it yet. The help page includes several examples of how to use it. The attached workflow contains snippets that show how to accomplish these tasks in Designer. Three examples are explained below.
View full article