Showing results for 
Search instead for 
Did you mean: 

Inspire | Buzz

Welcome to the Inspire Buzz -- the go-to community resource for Alteryx Inspire conference attendees. Ask questions about the events, connect with peers & share your experience!
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

Give us Your Best Tips and Tricks - Calling all Tip Meisters for Inspire 2019!


This is a bit of an advanced tip.  I don't use it often, but when I do it saves me tons of time.

Need to do something in tool configuration that (for whatever reason) the Alteryx UI really doesn't want you to do? (EG: Add a field to a Summarize tool that doesn't yet exist in your data because it is coming from a macro or cross-tab function)


You can edit these in line inside of Alteryx if you have the "XML view" enabled.


Then you can set up everything else about your process in the tool (In my Summarize example, the final output, the operation, separators, etc).


Next, click your fancy new "XML" icon:



Click Edit, and you have an in-line configuration editor, where you can change the name of the field!




Once we click "OK", we'll see that the configuration is now set up, and if I add the field later, it will work exactly how I want.



This will work for every tool on the canvas, although some are easier than others!

Alteryx Partner

really time saving...

Alteryx Partner

Sometimes Alteryx in-db (In-database tools) queries get really complicated, and it's not possible to understand what is going on without disecting the SQL in a text editor...


If you haven't seen the inner workings of an In-db query yet one of the previous posts includes that already. Just place a Dynamic Output In-DB tool at the end of your In-DB workflow and it will return you the query.


In order to simplify the query there is a simple trick, place a write-in db and the query will be simplified right after that;Picture1.png

This query will




turn into this smaller one;





Attached the relevant document where I've found out the trick for in-db...





Alteryx Certified Partner

Document a running workflow


Here's one I found recently,


If you're running a really long workflow, you might think all you can do is make a cup of coffee and come back in an hour. Instead you could find a tool using Ctrl+f and after selecting a tool / comment box edit the annotations while the workflow is running!


Capture.PNGEdit documentation while a workflow is running

Alteryx Partner

It's not necessarily an "Alteryx tip" because it's not related to the tools but a capability of the "DB" in in-db. And there is no mention of it in help or community either...


If you are connecting to an Oracle database you can get faster results with adding a short hint to your SQL query;


for a query like this

SELECT customers.cust_first_name, customers.cust_last_name, 
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;


add /*+ PARALLEL(4) */ and the SQL becomes this;


SELECT /*+ PARALLEL(4) */ customers.cust_first_name, customers.cust_last_name, 
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;


You can check out the inner workings here;

Alteryx Partner

There is a similar capability for SQL Server too...


FROM Sales.SalesOrderDetail



Copy and Paste tools, Comment boxes, Tool Containers on the Canvas


If you do a lot of copy and pasting of objects on the canvas you might do a quick Ctrl+c/Ctrl+v to duplicate a tool.  If you do Ctrl+v you've probably noticed that the new tool will paste to the lower right of the original and then you will need drag it to where you want it to go. If you are trying to move the new tool a long distance on the Canvas this can be a little tedious.  Here is the trick:


Instead of using Ctrl+v to past the new object, right click your mouse and choose Paste. This will paste the tool at your current mouse location!  No more dragging across the canvas!


(In the example below the first paste uses Ctrl+v)

copy and paste.gif

Peter Stoddard
Premium Support Advisor
Alteryx, Inc.

Alteryx Certified Partner
Alteryx Certified Partner

I have another useful tip for people who like to build simple iterative macros.


If you want to manually set up the the number of iterations (or let the user decide by using an Interface Tool), you can tell when your iteration process must stop with a Filter Tool and the Engine Iteration Number:



In this example, I want my macro to iterate 5 times, so when it reaches the 5th iteration (my Iteration Number starts at 0), the True Side will be completely empty (no records will go through, due to the condition being entirely False), and when the Loop Output is empty, the macro stops being iterated.



ACE Emeritus
ACE Emeritus



@thizviz aka cbridges, Bolide

A trick that I found and helped me immensely while creating/testing workflows is that you can copy the results from the results window and simply click on the canvas and press CTRL+V. Alteryx creates a new Text Input tool filled with the results you just copied. If you "Copy with Headers", the headers become column headers in the text input as well.