cancel
Showing results for 
Search instead for 
Did you mean: 

Inspire 2018 | Buzz

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

2018 Inspire Tips and Tricks : Calling out Tip Meisters

Alteryx
Alteryx

A big shout out to our Tip Meisters for providing useful and creative Alteryx tips & tricks. We shared them with our community at the 2017 Inspire session, their contributions were immortalized in the booklet as well.

 

And here we go again… If you have a tip and trick you would like us to share at our upcoming Inspire session, please post it here, there is no tip or trick too small or too obvious…

 

For your contribution, you will get our brand new 2018 tips and tricks community badge.

 

Inspire18_tipstricks.png

 

 

…we will give you full credit if included in the booklet…here is a sample from last year's booklet (thanks chris_love) :

 

tipfrommeisters.png

 

 

 

 

 

 

 

 

 

… and our eternal gratitude :)

 

See you at Inspire !

 

Margarita, Jess and Henriette

Alteryx Tips & Tricks Club

 

 

 

Margarita Wilshire
Sr. Supervisor, Customer Support Engineering
Asteroid

Use tool containers to group tools in your workflow that perform a specific function and give them meaningful labels. This is useful for you if you have a giant workflow as you can right click and use the zoom feature to zoom in on a specific tool container. 

Alteryx Certified Partner
Alteryx Certified Partner

@MargaritaW,

 

Using "GROUPs" of workflows.  Sometimes you will want to look at 2 workflows on a single instance of Alteryx.  You can divide the canvas either horizontally or vertically and see 2 workflows at once.  Following these step by step instructions you will see how to create the groups and how to restore them.

 

  1. Right-Click (R-C) the workflow that you want to move to a new group
    capture.png
    capture.png
  2. Select "New Horizontal Tab Group"
    capture.png
  3. Watch the magic happen
    capture.png
  4. To move the workflow back, R-C the tab
    capture.png
  5. Select "Move to Previous Tab Group"
    capture.png
  6. Watch the magic happen (again)
    capture.png
  7. Bonus:  Do you know how I get my logo to appear in the workflow?
    1. Comment Tool
    2. Shape None
    3. Background Image
      1. Select your logo
        capture.png

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Moderator
Moderator

Thank you so much @SGolnik  and @MarqueeCrew for kicking us off!!

Jessica Silveri
Customer Support Engineer
Quasar

If you want to extract a piece of data from a string where the strings around the data don't change (really useful for getting tokens for use in access authentication for the downloader), you can use a simple marked group in the RegEx tool set to tokenize.  Past your string into the Regular Expression box then replace the piece you want to extract with (.+).  That will grab anything inside there.  One caution, is to watch for characters that need to be escaped such as / or ".

 

In this example I am getting a token for a web service that we will use for the rest of the day with all of our other calls.  It's encrypted so there's no way to tell what the string format is going to be, but I know what's around it is going to stay the same every time.  I just had to escape the quotation marks and slashes.  That's about as simple as you can get with RegEx.  I use it all the time to get information out of "string frames".

 

Capture.JPG

Alteryx Certified Partner

Keep your select, joins, summarize etc.. tools tidy by using "Forget All Missing Fields"

 

Forget.png

Alteryx Certified Partner

Use the Summarize tool to perform a unique, select & sort in one go:

 

Summarize.PNG

Alteryx
Alteryx

If you lose your workflow configuration window (e.g. you closed it), double click anywhere on the canvas white space to bring it back. 

Henriette Haigh
Principal Support Engineer, Alteryx
Alteryx Partner

 

If you want a way to document and share your workflows without providing the original files you can print directly to a PDF.

 

The default print preview may look like this:

 

1.pngI

 

For a more useable image use the Fit to Page command.

 

2.pngrr

 

This will adjust the image so that you see something like this

 

3.png

 

 

The image defaults to including the file name and location in the title.

 

Alteryx Partner

 

Need a 30 year calendar with all the months and quarters?  Here is a quick way to build a calendar table.

 

2018-02-10_00013.png