-
PAT Publish to Tableau Server
PAT Publish to Tableau Server v1.1.0 Adapted from the Publish to Tableau Server tool Developed by Alteryx. Publish data to an instance of Tableau Server or Tableau Online. This tool is compatible with:* Alteryx 2018.2+ * Tableau Server 10.5+ Current known issues: * PAT tokens can only be used by a single application at a…
-
Google Auto Translate Macro
If you need to translate your text from one language to another, the process can be quite painful. The current Google Translate tool requires an API key, and billing information to get started. I thought it would be great to have a tool you can download, and not have to worry about where to get an API key or have credit…
-
File Directory Manager
This Macro has multiple actions with the purpose of moving or copying assets (files or folders) to a new location. In addition to an assortment of different actions for moving files, folders, or their contents, there is also a selection for an override policy. This should be used to decide whether the Source Asset replaces…
-
Dynamic Directory Tool
1. Challenge:I needed to poll the Alteryx temp directory for files, to pick up work to process. The Directory tool is a "root" tool and runs once before all your other tools, regardless of position in the workflow, so it would never see the files.Alteryx also has a different temp directory on each run, and the file names I…
-
OpenAI ChatGPT 4 (Completions) Connector
INTRO Warning: This macro uses throttling and requires AMP to be turned OFF. Note: *Macros are now available for o1 and o3-mini models - check the gallery* This macro will allow you to send data to OpenAI's ChatGPT AI. This version of the macro is a connector to ChatGPT4. The original Completions macro connected to ChatGPT…
-
SAP Office of Finance Starter Kit
This is the Alteryx Office of Finance Starter Kit enhanced with fast, secure SAP integration. Download the Starter Kit to get started with pre-built workflows showcasing the best of SAP integration, direct to tables and transaction codes. Starter Kit Features Reconcile SAP Assets and LiabilitiesQuickly reconcile your data…
-
SAP Finance Starter Pack for Indirect Tax Calculation
Blend external data with SAP customer records to identify a customer’s home state and allocate indirect tax accurately. This workflow takes the Alteryx Office of Finance Starter Pack workflow and extends it to provide secure access to an SAP data source. It offers a practical starting point for quickly exploring and…
-
SAP Finance Asset and Liability reconciliation
See how to pull asset & liability data directly from SAP using the DVW Alteryx Connector for SAP - including running SAP transaction codes (T-Codes) so you leverage SAP’s inbuilt business logic (as if you were in SAP GUI). Then reconcile SAP results against an external validation data source, apply consistent preparation…
-
SAP Finance Year to Date KPIs
Accessing SAP Finance data in a flexible way can be challenging, particularly when repeatable and secure access is required. This workflow combines the Alteryx Office of Finance Starter Kit with DVW’s Alteryx Connector for SAP to provide a pre-built integration for accessing SAP Finance data in Alteryx. It offers a…
-
Dynamice Select DataType
Dynamic Select is missing one important part, change the datatype. for example, in this discussion, https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Compare-tow-sheet-column-by-Column-amp-update-Match-and-mismatch/td-p/1430569 OP require to compare multiple columns in 2 table and return a status…
-
Random sort
There wasn't an easy way to randomly sort your data; this macro helps do that, by taking your data and changing the order and outputing it with the same fields going in.
-
Convert .xlsb into .xlsx and parse the input
As we all know, there are some challenges when dealling with .xls/.xlsm/.xlsb files as input. Because of this, i built this macro that convert .xls into .xlsx and parse the data. This macro uses the python component with the libraries openpyxl, xlrd and pyxlsb. OBS: The python libraries were added as assets on the package.
-
Designer Cloud Telemetry
Brought to you by Alteryx Customer Solutions SaaS platforms execute complex workflows and jobs in today's cloud-driven era, but a lack of analytics hinders operational efficiency. By harnessing job execution data analytics, businesses can uncover inefficiencies, optimize resources, and drive transformative improvements.…
-
Office of Finance Starter Kit
Get Started with Finance Automation Download the Office of Finance Starter Kit to get started now. With these pre-populated workflows and solutions, you can tackle a variety of tax & audit projects such as: Tax * Sales tax reporting * Income tax provision compliance * Fixed asset depreciation * R&D calculations * Sales…
-
Workflow Summary Tool - Powered by Generative AI
Download * Build for Designer 24.1 and later: https://downloads.alteryx.com/Tools/WorkflowSummary-py3.10-v1.2.0.yxi * Build for Designer 23.2 and earlier: https://downloads.alteryx.com/Tools/WorkflowSummary-py3.8-v1.1.0.yxi Notes Please read this blog post to learn about the AiDIN-powered Workflow Summary Tool and…
-
Interface List Macro
Macro Installation 1. Challenge: What is the problem or issue that you're attempting to solve?Interface tools in Alteryx expect values to be provided in a specific column-based format, which can be cumbersome when the source data naturally exists as a simple list or row-based structure. Manually reshaping, deduplicating,…
-
Move Item Macro
Macro Installation 1. Challenge: What is the problem or issue that you're attempting to solve?Workflows output files to folders that may reside on network locations, shared drives, or external storage systems. These environments can introduce latency, file-locking behavior, or temporary availability issues that are outside…
-
Pause Macro
Macro Installation 1. Challenge: What is the problem or issue that you're attempting to solve?Some workflows depend on external systems or services (such as APIs, webhooks, databases, or file-based integrations) that operate outside the control of Alteryx and may impose timing constraints, rate limits, or processing…
-
European Central Bank Euro Foreign Exchange Reference Rates
Macro Package Installation 1. Challenge: What is the problem or issue that you're attempting to solve?The European Central Bank (ECB) publishes new euro foreign exchange reference rates daily. Those are used to be able to convert local currencies into euros and must be updated regularly to maintain accurate books. 2.…
-
Multi-Row -Field -Column Macro example
The Multi Row – Multi Field tool allows you to create or update multiple fields with the ability to reference other rows and columns. It combines the best of the multi-row and multi-field formula tools, plus adds multi-column formula syntaxing. See the word doc and example workflow for more details. After opening the yxzp…
