Alteryx summarize tool code#
Alteryx summarize tool free#

Alteryx summarize tool free#

The problem is, if a user is given free reign to choose any dimensions and measures, I can solve the Group By problem and Sum issue, but not the Formula issue because the name of the measure changes depending on order of item selected or even the field selected for aggregation. With the control container, is it possible to add it to the workflow so that a chain app can be avoided? Basically, the DB will output a YXDB and will connect to the workflow simultaneously, but the YXDB will serve as the drop-down/list-box options of the interface.Īfter an interface is created, I need to connect it to a formula tool in order to calculate the / always. As I intend to use an Analytic App to utilize Dynamic Summarize, what BenMoss did with his Macro needs to be replicated on the Canvas for an Analytic App: Doing so enables the interface to interact as his macro. How do I configure the interface tools further so that end-users can just choose their dimensions & measures of choice? For anyone wondering if a Dynamic Summarize is possible, BenMoss' workflow macro solves it. Mind you, the original source actually comes from a Database, but I have used a dummy value in order to simulate what I need. I am having a hard time creating an interface whereby users can select their dimensions & measures of choice based off the dataset. I have also attached the workflow and macro in this post. Study with Quizlet and memorize flashcards containing terms like Given the output below, which is the correct configuration of the summarize tool. We also spent some time determining effective prompts to get the ChatGPT models to usefully summarize our workflow text.I got this fantastic Dynamic Summarize macro from BenMoss here.

Alteryx summarize tool code#

These include selectively extracting meaningful tool configuration options (the text but not the color of a Comment tool), individually summarizing especially long tools (for example an R or Python tool with a lot of code in them), and summarizing groups of tools (in containers, or in order of the workflow flow) and then summarizing the summaries.

So we developed a set of strategies to convert each workflow file into text of a length that the ChatGPT model can accept. We initially found that the files defining most workflows were too long for ChatGPT in their raw form. When ChatGPT first took the world by storm a few months ago, we saw an opportunity to summarize Alteryx workflows in plain English using the OpenAI APIs. Below is my Day 10 workflow - but when I opened it up, I had forgotten what it did! So I pulled in the Workflow Summary tool from the Laboratory toolbar (see installation and setup instructions here), connected it to my DCM connection for my OpenAI API key, and configured it to Summarize “Current Workflow”: Unfortunately, I tended to be in a rush and not paying much attention to documentation as I created my workflows for the various days. Last December, I participated in the Alteryx “BaseA” Advent of Code challenge.

Just pull the Workflow Summary tool into a single workflow or point it at a whole directory of them, connect your OpenAI API key, and presto! The tool outputs a few-word topic, a headline, and a paragraph-length summary for each workflow! It gives you the choice of storing this summary in the Workflow Info Description field (accessible by Alteryx Server when a workflow is deployed there) and/or sending the summary downstream from the tool for export to a file or further analysis.ĭownload the Workflow Summary tool here and give it a spin! Alteryx AiDIN is the AI engine that infuses the power of generative AI & Machine Learning (ML) across the Alteryx Analytics Cloud Platform. Today we’re releasing… (drumroll please…) the Workflow Summary Tool! This is a new AiDIN-powered Designer Desktop tool that leverages OpenAI’s ChatGPT to automatically provide concise summaries of a workflow’s purpose, inputs, outputs, and key logic steps.