-
Dynamic Metadata (Unicode) (Based on the CReW Macro)
Disclaimer: This macro was based on CReW Dynamic Metadata from CReW Macros set and is in no way related with or quality checked by CReW team. The CReW Macro pack credit belongs to its original developers. Credits for original CReW Wildcard Input Macro: Macro Author: Adam Riley This macro, which is based on the Dynamic…
-
Larss A Ogren Portfolio
Looking to detail my portfolio and share with the community
-
Upload Pricing Conditions to SAP
I'm a pricing manager who has just been handed two hundred customer-specific discounted prices. Without the DVW Alteryx Connector for SAP (ACS), this would involve opening SAP and hitting VK11 two hundred times. This workflow shows a better way, loading data through an IDoc and validating the results automatically.
-
Extract Pricing Conditions from SAP
I’m a sales analyst three weeks before quarter end. My regional VP wants a target list of customers who’d respond to a discount. The data I need is sales history, customer master and payment data, all contained in SAP. Traditionally this would involve manual downloads and many data prep steps. This sample workflow shows a…
-
Control Container Gatekeeper Macro (Execution + Error-Aware Flow Control)
DescriptionThis macro acts as a gatekeeper between Control Containers by evaluating the execution results of a Control Container before allowing the next Control Container to activate. It inspects the Control Container output log to determine: Whether the container actually executed (i.e., did the tools within the Control…
-
NeoInfiniTech Directory
This macro is designed to read in directories specified with environment variables. The macro also presents the information regarding the mode being used, subdirectory choice and number of files read as a message.The "CReW_" prefix was added only for file sorting convenience (when installed into CReW macro pack directory)…
-
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 time,…
-
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 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 dealing 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 apportionment…
-
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 read this…
-
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,…
