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
MarqueeCrew
20 - Arcturus
20 - Arcturus

@JessicaS,

 

No warnings is a tip.  Avoid warnings that you're going to ignore.  When configuring a tool like the UNION, don't use the default configuration.

 

capture.jpg

 

Try to keep your workflow free from warnings and pay attention to the messages after you run.  Also, if you use the Manual Config option, if you allow dynamic fields to flow into the union you will get error messages.  Just a warning :)

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
PeterS
Alteryx
Alteryx

Right clicking is like a secret universe.

 

With one or more workflows open, right click on a workflow tab to see different options available.  I personally use 'Open Containing Folder' quite a bit.

workflow tab right click.jpg

 

Once your workflow has completed and has generated a file with the blue hyper-link, left click the link to immediately open the file.  Or right click to quickly open the folder the file was created in!

workflow results right click.jpg

 

Peter Stoddard
Manager, Technical Account Management
Alteryx, Inc.


DataKyle
8 - Asteroid

Someone probably put this here already, but this helped me with a workflow issue recently:

 

If you have a workflow that seems to be taking a long time to complete, you can enable workflow performance profiling from Workflow Configuration -> Runtime -> Enable Performance Profiling.

 

Note: Workflow may take a little longer than normal to complete but the output will include some interesting data to help solve your issue.

 

Here you can see the time each step took and the percentage of total. In this workflow the primary driver is the initial data pull from Oracle.

profile.PNG

sk1909
8 - Asteroid

I really like this one and I use it a lot.

Kenda
16 - Nebula
16 - Nebula

I am forever accidentally typing over expressions I just wrote in Formulas, Filters, etc. so I always use the "crtl + z" keyboard shortcut! If you need to undo something within a single expression, use this shortcut to go back a couple steps.

 

In the below example, I accidentally typed c instead of doing "ctrl + c" to copy my selection. Dang it! Now not only have I not copied what I intended to, but I also wrote over it and lost that text. Never fear! I can easily hit "ctrl + z" to undo the c and get my text back in the expression.

ezgif.com-video-to-gif (1).gif

 

estherb47
15 - Aurora
15 - Aurora

Tired of counting/guessing how many columns you need for the Text to Columns tool? Let Alteryx figure that out for you!!

 

By combining Record ID, Text to Columns, Tile and Cross Tab, you can have a more dynamic parsing experience.

 

Before parsing your data, drop in a Record ID tool to uniquely identify each row. We'll use this field in the Cross Tab tool to rebuild the original table.

 

image.png

 

Next, add your Text to Columns tool, and type in the delimiters. But, instead of splitting to columns, split to rows instead.

image.png

image.png

 

Now we need to build a field to represent which column each row of data should be in. Use the Tile tool, set to Unique Value, with the Record ID as the Unique field. The resulting Tile_SequenceNum field will number the rows within each Record ID, from 1 to n (n being the last one)

image.png

image.png

Finally, rebuild your table using the Cross Tab toolimage.png

image.png

If your first row contains headers, use a Dynamic Rename tool to pop that first row into the header row. Otherwise, use a Select tool and rename the columns.

Cheers!

Esther

rag-ryx
9 - Comet

Hello Alter-nation people,

 

I am excited to be at Inspire 2019. I have learned few things during my couple of years using the one and only greatest Data tool - to have ever lived on Planet Earth: Alteryx.

I am not sure if you will call them as tricks but I find them pretty handy, so here we go - 

 

1. In-DB workflow takes too long?

Problem - While working with huge data sources like Spark and creating work flows, sometimes it takes a considerably long time to run the workflow. Even with In-DB tools, especially if you are using multiple tables (multiple Connect In-DB tools), joining them and doing some more manipulation. 

 

Tip 1 - In such cases, try writing a simple SQL query to - 

  • Select only the columns you need
  • Join the tables in the select query
  • Do any date/string conversions needed in the query

And use that query in 1 Connect In-DB tool instead of using multiple Connect In-DB tools. No need to write complex queries, a simple query to fetch the data you need is enough.

You will see a considerable decrease in workflow completion time (depending on the overall workflow logic).

 

Tip 2 - In scenarios where you need to stream your final data set out of In-DB, so that you can use other tools and perform other actions. Try using a Normal Input Tool & write your SQL query in the tool. Sometimes people forget that we don't have to use In-DB tools all the time. An input tool can give the same performance or even better. I have seen better performance in using an Input tool and getting my data compared to using multiple In-DB tools and then streaming the data out.

Things to remember - You will need to write an optimized SQL query to use this tip efficiently. 

 

2. Alteryx hangs and needs to be closed?

Problem - Many times when we have multiple workflows open and data cached and we try to open a new workflow (especially an In-DB workflow) - sometimes designer hangs for a while and if you clicked impatiently you might have to restart it. In such cases you will have to run your workflow again to cache the data and start developing your workflow from that point onward. It can be frustrating.

 

Tip - Always have an unsaved workflow open in your designer. An unsaved workflow is highlighted by a small asterisk sign after the workflow name.

Now if your designer hangs, just Right Click on the designer logo in Taskbar (at the bottom) and Click on Close Window.

Since you have an unsaved workflow open - the designer will ask you to first save the workflow or not. And voila the designer isn't hung anymore and you don't have to restart it, thus saving time from rerunning everything.

 

Unsaved workflow.PNG

 

3. Can't write a SQL query?

Problem - As per my Tip 1, you want to write a SQL query to replace your In-DB workflow. But you don't have much experience in writing queries or your workflow is too complex and you are not sure how to start writing the query.

 

Tip - Worry not, because Alteryx will do this too for you. Just place a Dynamic Output In-DB tool at the end of your In-DB workflow and it will return you the query, designer generated for your complete workflow. Now you can take this query and edit it as per your need, instead of you having to start writing a query from the scratch. Once done you can use the query in one Connect In-DB tool or Input tool and replace the whole workflow with just one tool. Any changes further would need to be done in the query itself.

 

2.PNG

 

Hope this is helpful.

Keep Alter-ing lives.

 

Best,

Raghav

 

mbarone
16 - Nebula
16 - Nebula

One of my favs . . . 

 

Have several different tools that you want to connect to ONE distinct tool?  Say, five Text Input Tools to one Union Tool:
20190522-01.jpg

 

You don't have to manually connect each one.  Instead, select all the tools you want to lead into the one tool (I like to use the lasso technique to select them all at once):
20190522-02.jpg20190522-03.jpg

 

Then right click on one of the selected tools and choose "View Possible Connections":

20190522-04.jpg

 

 

In the window that opens up, all your lassoed tools will be checked already on the left.  Simply check the one tool you want to connect them to on the right, and click "Connect":
20190522-05.jpg

 

 

And just like that, instant multiple connections :)
20190522-06.jpg

 

 

Hope to see everyone in Nashville!  

Thableaus
17 - Castor
17 - Castor

This tip is simple but sometimes people forget about the simple features as well.

 

If you are having trouble with something in Alteryx and you want to quickly ask the Community, you can access the web page through the Help Window.

 

Help.png

 

 

Cheers,

Greg_Murray
12 - Quasar

This is a simple one. 

 

Use an open bracket ([) when looking for fields in the formula tool. It will filter the active search to only field values

field_choice_gif.gif