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!

Asteroid

Also adding an email event (under the Events tab) if you are the workflow owner/administrator.

 

Email event.PNG

 

This will allow you to get notifications when the workflow is ran based on options you select. I.e want to know when the workflow runs, if it runs with errors, or without errors, et. cetera.

 

Email event options.PNG

 

 

Pulsar

I recently discovered that you can make your text bigger within the Configuration Window! Simply click in the expression editor you want to zoom in on, hold the Ctrl button then scroll up on your mouse! You can also make the text smaller by holding Ctrl and zooming out with your mouse.

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

 

 

The same thing can be done in the SQL Editor!

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

ACE Emeritus
ACE Emeritus

When posting solutions in the forums, add screenshots, such as @patrick_digan @D12monkey and @BarnesK have done in this post.

 

It makes it so much easier for people to find solutions without needing to open the packaged workflow to see the backstage magic. :-)

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

Two more:

 

1: You can re-name tools allow easy trouble shooting of your workflows.

Do this by selecting the tool, clicking the tag icon and changing the Name and Annotation (as shown in red below).

Changing the annotation will organize your workflows for quick reference.

For example:

 

Changing the Name will allow you to use the find tool feature (Ctrl +F) and select the exact tool you want to edit:

 

2: This tool works well in conjunction with the above tip. If you have your tools named you can use this tool via Ctrl+F or via the view menu:

You can sort your tool by Name or by number by selecting the hyperlinked sort by toggle near the X to close.

Alteryx Partner

Here's something that I recently discovered, which I never knew because it's too obvious.  When you're reviewing your workflow output in the results section, you sometimes find some interesting data.  You can pop the results out into another window while you go off an explore the underlying data.  But sometimes, the results set is very large, and you may lose your place in the records you were exploring.  In this case, you can pop out the selected records into a new window, rather than all of the records in your results.  You also have the option of saving the record subset as it's own table.  

 

 

Browse.png

Explore.png

 

Pop Out.png

ACE Emeritus
ACE Emeritus

Here's a troubleshooting tip I learned the hard way (by getting weird results and ultimately working with a solutions engineer).

 

If you're not getting expected results, especially along the lines of numbers that should be 123 coming out as 122.88759, try adding a data cleanse tool or a formula tool {ToNumber([field1]) or IF IsNull([field]) THEN 0 ELSE [field] ENDIF} toward the beginning of your workflow to convert NULLs to zero. Believe it or not, it can make a difference.

 

Second troubleshooting tip:

If you're not seeing the number of records you expect, or if data seems to be dropping out of your workflow, turn on Connection Progress in the configuration window. You'll be able to see exactly where the record count drops. If you're still not sure exactly what's going on, add browse and/or summarize tools to the false side of Filter tools and un-used anchors on Join tools. Use the data profiler or group function in the summarize tool to determine what those records have in common (for instance, if you're filtering for ABC, Inc. and these records say ABC, Inc or ABD Incorporated and you didn't know that).

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

In the Select tool, if you're choosing only a few fields from your dataset, and want to sort the ones you've already selected (or just want to see them close together so that you know which fields you've selected so far), you can click on the tiny box in the upper left corner so that all the fields you've chosen are all together. You can then sort them easier instead of going through all the ones you did not select.

 

select 1.PNGStep 1: Choose desired fieldsselect 2.PNGStep 2: Click that box in the upper left corner (twice) so that your chosen fields are now all together

Alteryx Certified Partner

Hi!

 

I posted this one through my LinkedIN profile, maybe it could be useful:

 

"Cross-Tab tool is a great resource to bring your rows to column headers in Alteryx. But, we have to admit that the process of turning every special character present on the field names to an underscore can be very annoying.

There's an easy way to correct this behavior. Using Unique Tool with the power of Regular Expressions, you are able to setup the Dynamic Rename tool to easily go back to your original headers as they should be. Unique Tool is important to get only a single record per field name. Formula Tool is applied with REGEX_Replace, so we're able to create a lookup field that is similar to what Cross-Tab tool does : all non-word characters become underscores. Finally, the Dynamic Rename Tool allows the user to rename fields based on two fields from a different data stream - the regular name and the underscore name are then compared.

Drop the multiple hardcoded renaming with your Select Tool and simplify!"

 

 

 

Quasar

Don't forget the various canvas options that can make life easier.

 

I particularly like to use Runtime tab, Disable All Tools that Write Output. It's great when debugging what's up without having to wait for large outputs to be written or to stop a failing workflow for messing up a downstream input.

 

Also on the same tab, Enable Performance Profiling can show you where your workflow has bottlenecks. This can guide you to better design decisions.

 

Use Meta Information tab to help document the workflow

 

XML tab (if enabled) can really help if you want to find how and where certain strings / elements are used prior to making global changes

 

Meteoroid

Quickly add a Browse Tool to all selected outputs by pressing CTRL+Shift+B!

AddBrowseTip2.gif