community
cancel
Showing results for 
Search instead for 
Did you mean: 

Inspire 2019 | Buzz

Stay up-to-date, connect with peers & share your experience!

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

Magnetar
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!

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

Picture2.png

 

 

turn into this smaller one;

Picture3.png

 

 

 

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

 

Best

 

 

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, 
  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

Alteryx Partner

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

 

SELECT *
FROM Sales.SalesOrderDetail
OPTION (MAXDOP)

 

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

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:

 

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,

ACE Emeritus
ACE Emeritus

Wow!

8-O

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

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.