Check out the Inspire breakout session catalog! From inspiring stories about business transformation to analytics best practices, our breakout sessions have something for everyone.  

Inspire | Buzz

Ask questions, connect with other conference attendees, and share your experience.

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

JessicaS
Alteryx Alumni (Retired)

InsInspire19_tipstricks.pngpire 2019 is just around the corner and we're calling on you to help us with Tips and Tricks for the session. 

 

We're looking for your "Aha!" moments, your "I cant believe I didn't know you could do that" realizations, and anything you do in Alteryx to save clicks.  What are your go to time savers that the Community could benefit from? Please post in the comments and share your tips with us.

 

 

Everyone that posts a tip in this thread will get the Tips and Tricks 2019 Badge!

 

2019-03-12_16-51-33.png

 

If we use your tip in the book your username will also be featured. 

 

We will have special swag for Tip Meisters who are featured in the book that come out to attend our session in Nashville. 

 

 

 

 

For tip inspiration check out last year's post and book

 

 

Adding a special thanks to everyone w2918 tIPS LINE.pngho submitted content in 2018 and came out to the session. 

 

As you can see from the picture, we had a huge turnout in Anaheim!  We had to add an encore session to make sure everyone that waited in the line got to see the session. 

 

 

 

 

 

 

 

 

 

As always, thanks for your support and we look forward to seeing y'all down in Nashville!!

 

 

- The Tips and Tricks Team ( @MargaritaW , @JessicaS  and @HenrietteH )

Jess Silveri
Manager, Technical Account Management | Alteryx
45 REPLIES 45
Claje
14 - Magnetar

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.

claje_enableXML.PNG

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

claje_xml2.PNG

Next, click your fancy new "XML" icon:

claje_xml3.PNG

 

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

claje_xml4.PNG

claje_xml5.PNG

 

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.

claje_xml6.PNG

 

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

Atabarezz
13 - Pulsar

really time saving...

Atabarezz
13 - Pulsar

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

Picture2.png

 

 

turn into this smaller one;

Picture3.png

 

 

 

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

 

Best

 

 

PhilipMannering
16 - Nebula
16 - Nebula

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!

 

Edit documentation while a workflow is runningEdit documentation while a workflow is running

Atabarezz
13 - Pulsar

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, 
  MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
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, 
  MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
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; https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

Atabarezz
13 - Pulsar

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

 

SELECT *
FROM Sales.SalesOrderDetail
OPTION (MAXDOP)

 

PeterS
Alteryx
Alteryx

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
Manager, Technical Account Management
Alteryx, Inc.


Thableaus
17 - Castor
17 - Castor

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:

 

IterativeMacro.PNG

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.

 

Cheers,

ThizViz
11 - Bolide

Wow!

8-O

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
akshada_r
5 - Atom

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.