Welcome to the Alteryx Community!

The Alteryx Community is a valuable resource for new users and advanced experts. Sign in and make your voice heard.
Get started: post questions, browse best practice recommendations, and share your expertise and experience using the fastest platform for designing and publishing analytics.
  • Use the search box above to quickly find what you specifically need to craft and deploy analytics.
  • Click the Forum tab to connect with other users, browse answers to previous questions, or post your own question.
  • Select KnowledgeBase to get up and running with access to hundreds of articles, sample modules, and analytic applications.
  • The Idea center is a place to post enhancement requests, vote on existing ideas, and connect with our product management team.

Category:

I have a project with a test tool connected to data streams that go to 3 separate output tools.  If the test fails, output is only blocked to one of the three output tools.  The ou ...
Posted By: jgreene
Posted On: 09/02/2014 10:42 AM
Comments: 7
Category: Developer
Hi all,

I'm trying to implement a simple JOIN of two tables on a date range.

Here is the scenario:

 i) Transactions table got transactions for every day.
Date + Product + Qu ...
Posted By: sandeep.chayanam
Posted On: 08/29/2014 09:13 AM
Comments: 0
Category: Join
You can call me new school, but when I browse for inputs etc. in Alteryx, they are the old school windows interface where I have to hunt and peck through the file directory.  Can y ...
Posted By: sean.otto
Posted On: 08/28/2014 02:12 PM
Comments: 2
Category: Common Use Cases
Status: Under Review
Dear Alteryx,

Alteryx 9 new Macro configuration module, is great
One thing that could be improved :

For Iterative macros, it's very frustrated to set a Maximum of Iterations ...
Posted By: arnaud.langlois
Posted On: 08/28/2014 01:50 PM
Comments: 1
Category: Macros
Status: Not Planned
This should be quite easy to implement. I think it would be great if could we have:

1. A User repository for macros in the Users folder, e.g. My Documents\My Alteryx Macros\

This ...
Posted By: chris.love
Posted On: 08/28/2014 01:44 PM
Comments: 0
Category: Macros
Status: Coming Soon
Hello fellow artisans,

I have two columns in csv format. Both are strings. I would like to measure the similarity using the fuzzylogic node in Alteryx. I only need two compare the ...
Posted By: paolo.carbone
Posted On: 08/28/2014 11:55 AM
Comments: 0
Category: Data Investigation
For example, in the Properties tool (I say that generally because it could be in more than one place in that tool) all the user to enable to visibly see the path of the variable in ...
Posted By: sean.otto
Posted On: 08/28/2014 10:14 AM
Comments: 0
Category: Common Use Cases
Status: Under Review
When workig on a module with many tools, and one of those tools is the Allocate Input tool (Experian US), whenever you try to access or configure that other tools, there is a delay ...
Posted By: mbarone
Posted On: 08/28/2014 09:57 AM
Comments: 1
Category: Calgary
Status: Planned
I have several modules that need to run in sequence.   Can a ksh or some other program be used to string the modules together?  

So that if I have Step1.yxmd, Step2.yxmd and Step3 ...
Posted By: jmoney
Posted On: 08/28/2014 09:51 AM
Comments: 3
Category: Troubleshooting
Status: Under Review
If we rename a field ‘X’ to ‘Y’  in the alteryx module, the renaming is not inherited by all the tools using that field in that module. The tools which are still using the old fiel ...
Posted By: shashi.lingaiah
Posted On: 08/28/2014 09:44 AM
Comments: 0
Category: Preparation
Status: Under Review
In the ‘Report – Table’ tool I would like to be able to force headings to multiple lines. For example If I have a heading such as “Catchment (%)” or “Spend (£)”, I would like there ...
Posted By: joe.lipski
Posted On: 08/28/2014 09:43 AM
Comments: 0
Category: Reporting
Status: Under Review
A client contacted us recently asking if there was a way to view the log file of a scheduled process during runtime.  The use case is so that if there is a runaway process, they wi ...
Posted By: cmartin
Posted On: 08/28/2014 09:42 AM
Comments: 1
Category: Developer
Status: Under Review
The field selection pane in Multi-Field Formula is very small and not resizeable. It is difficult to select anything other than all variables when only 4 1/2 fields are displayed a ...
Posted By: tom.montpool
Posted On: 08/28/2014 09:41 AM
Comments: 0
Category: Preparation
Status: Under Review
I think that it would be useful to add two new Rename Modes to the Dynamic Rename tool -- here are the existing ones:


I would add:
Take Field Metadata from Right Input Metadata
T ...
Posted By: tom.montpool
Posted On: 08/28/2014 09:39 AM
Comments: 1
Category: Developer
Status: Under Review
Leverage Oauth 2.0 security protocol for the Alteryx salesforce.com connector
Posted By: adrian.boeh
Posted On: 08/27/2014 02:57 PM
Comments: 3
Category: Connectors
Status: Under Review
Hey all,

I have built a module that reads in a very long Word doc (1800+ page) to extract certain pieces of data that I'm interested in bringing into a table.  Some data is fo ...
Posted By: jbednarz
Posted On: 08/27/2014 01:24 PM
Comments: 2
Category: Parse
Hi all! 

I want to customize the Interface Designer tabs to add pictures or logos in order to improve the UI. 

Anyone know how to do this? 
Posted By: sakenk
Posted On: 08/27/2014 01:01 PM
Comments: 1
Category: Analytic Applications
Imagine I have 10 dimensions and 1 measure.
The dimensions are such items as "Region", "Country", "State", "City", "Zip", "Ac ...
Posted By: michael_nealey
Posted On: 08/27/2014 12:09 PM
Comments: 1
Category: Data Investigation
How do I set up MongoDB as the database type under the persistence section of the System Settings? A list of thorough instructions including how to install and configure MongoDB as ...
Posted By: andrew.komaromy
Posted On: 08/26/2014 10:24 PM
Comments: 1
Category: Common Use Cases
Hi everyone,

I've been running a module for several months that crunches through the data, then exports into several Excel templates for presentation/distribution. Pretty much ...
Posted By: avoel
Posted On: 08/26/2014 12:34 PM
Comments: 2
Category: In Out
Can Alteryx Parse A Word Doc Or PDF?
Recently we were contacted asking if Alteryx can parse a word doc or PDF file. The quick answer is "no", but with the help of an open source program, it is possible!
Posted On: 08/26/2014 09:38 AM
Category: 
Add an option to read directly from a zip file.
Posted By: joe.strellis
Posted On: 08/24/2014 11:52 PM
Comments: 1
Category: In/Out
Status: Under Review
Currently when I open and run an app in designer mode im unable to access any other modules while it runs.  It would be nice to be able to work on other modules while an app runs w ...
Posted By: chris_cleckner
Posted On: 08/24/2014 11:51 PM
Comments: 1
Category: Analytic Appliances
Status: Under Review
I would like to specify two points on a map and have Alteryx create a spatial object that represents the best route from one point to another given some parameters such as quickest ...
Posted By: bgomez
Posted On: 08/24/2014 11:50 PM
Comments: 0
Category: Spatial
Status: Under Review
Within one of my modules I use the “Find Replace” tool quite often to find keywords within a customer name field.  By chance, I have found that irrespective of what order my keyw ...
Posted By: paulm
Posted On: 08/24/2014 11:50 PM
Comments: 0
Category: Data Investigation
Status: Under Review
Seeing how we use browse to tools to help build out modules, but they slow down the modules because they write out temp files, it would be awesome to have a "record count" ...
Posted By: chris_cleckner
Posted On: 08/24/2014 11:49 PM
Comments: 2
Category: Data Investigation
Status: Under Review
When building an expression (e.g. [Store Type] in ("Supermarket", "C-Store", "Gas Station") ) when the user selects the field variable, provide all th ...
Posted By: michael.team
Posted On: 08/24/2014 11:48 PM
Comments: 1
Category: Common Use Cases
Status: Under Review
I want the ability to select a field from my reference YXDB file in the Map Input tool to color-code the features based on their value. For example, I have a file of store location ...
Posted By: korycunningham
Posted On: 08/24/2014 11:48 PM
Comments: 0
Category: Spatial
Status: Under Review
As well as having the play and stop button in think it would be useful to have a pause button.
Posted By: joe.strellis
Posted On: 08/24/2014 11:47 PM
Comments: 0
Category: Common Use Cases
Status: Under Review
Is there a way to move a Connector?  Sometimes I need to add a filter between two tools and it would be less disruptive if I could manually move the connector, then deleting the co ...
Posted By: larrysanchez
Posted On: 08/22/2014 01:10 PM
Comments: 8
Category: Connectors
Hi,

I'm a fairly new user to Alteryx and I want to do some text analytics.

For example, I have PDF's, word documents and excel spreadsheets of information about Universit ...
Posted By: annieb
Posted On: 08/21/2014 08:26 AM
Comments: 2
Category: Data Investigation
  I have a transaction log that consists of a customer ID, an activity date and a state entered. I am interested in reshaping to reflect the time spent in a given state. The cha ...
Posted By: wayne.kramer
Posted On: 08/20/2014 05:16 AM
Comments: 1
Category: Transform
I am working with Decision tree in Alteryx. I see the option to set the depth of nodes in Decision tree. Is there an option to the set the number of branches in the decision tree?
...
Posted By: varungandhi.m
Posted On: 08/19/2014 02:47 PM
Comments: 1
Category: Predictive
Alteryx Technical Overview
Looking for an overview of all the technical capabilities Alteryx has? This article highlights a recently released document that covers your questions!
Posted On: 08/18/2014 11:26 AM
Category: 
Hello,

How would I handle transitioning my current license to a new laptop? For example, Tableau has a deactivate button. In Alteryx, would I use the delete license button?

Many ...
Posted By: kimr
Posted On: 08/15/2014 07:35 AM
Comments: 1
Category: Licenses and Activation
Hi

I am trying to parse an API with XML however Alteryx isn't rendering the Username and Password for some reason?

Also, as part of the API process there is a need to pass ba ...
Posted By: nick.lupis
Posted On: 08/15/2014 01:09 AM
Comments: 2
Category: Parse
R Tool: Predictive Analytics
WebEx session on basics for Alteryx R Tool
Posted On: 08/12/2014 11:26 AM
Category: MacrosPredictive
I have some date time information (currently UK GMT Time, but will expand globally) and am wishing to convert the time to UTC.
Have had a look around but other than using API's ...
Posted By: joe.strellis
Posted On: 08/12/2014 08:29 AM
Comments: 2
Category: Transform
I have some date time information (currently UK GMT Time, but will expand globally) and am wishing to convert the time to UTC.
Have had a look around but other than using API's ...
Posted By: joe.strellis
Posted On: 08/12/2014 06:31 AM
Comments: 1
Category: Transform
Hello,

I'm creating a inventory modue while using the ETS r function and the forecast function.  I can create forecasts for 1 item but how can I create forecasts for 1000 or s ...
Posted By: michael.weiss01
Posted On: 08/11/2014 05:21 PM
Comments: 2
Category: Predictive
Is there an easy way to build (or access) a file with all Zip Codes?  The Allocate Input tool only has access to Zip Codes with demographic information or polygons.  But there are ...
Posted By: larrysanchez
Posted On: 08/07/2014 10:15 AM
Comments: 4
Category: Spatial
How To: Properly Use A Detour Tool In An Analytic App
Analytic apps are becoming more and more relevant in today's Alteryx environment. For a great tip, try using the Detour Tool as a way to give the end user more options than ever!
Posted On: 08/05/2014 03:47 PM
Category: Analytic Applications
Hi,

I have tried several ways to join two tables to get the desired output. Do you have any ideas to do this.

Table A has two rows of data with tow unique IDs. There are multiple ...
Posted By: rama.kunaparaju
Posted On: 08/05/2014 02:08 PM
Comments: 3
Category: Join
Hi,

Can some one please let me know how to change the data field type to multiple variables in the select or join tools?  I want to be able to select multiple fields and change th ...
Posted By: mani.vannan
Posted On: 08/05/2014 12:56 PM
Comments: 2
Category: Preparation
How To: Properly Use Relative Paths
In this week's article, Zach Hamilton helps us explain how and when to properly use relative paths in your module and app development.
Posted On: 08/04/2014 11:00 PM
Category: Alteryx EngineTips and Tricks
Error: CASS Is Not Working! What Do I Do?
Installing CASS can be relatively straight forward, but sometimes issues arise. This article touches installation steps, then covers a few tips on how to resolve these common issu ...
Posted On: 07/30/2014 10:30 AM
Category: InstallationGetting Started with AlteryxDataAlteryx EngineAddress
Reading .xlsx And .accdb Into Alteryx Sometimes Has Issues
We often get cases where a user reports an issue with reading Microsoft Office files, such as .xlsx and .accdb. There are two primary cases, the first of which is being able to se ...
Posted On: 07/21/2014 02:24 PM
Category: DataInput OutputTroubleshootingAlteryx EngineIn Out
Inspire 2014 Session Content And Recordings Are Now Available!
Did you miss out on Inspire this year? Did you attend, but weren't able to make all sessions? We have now made the sessions available on Alteryx.com! Click through for more info ...
Posted On: 07/15/2014 09:17 AM
Category: 
Bi-Variate Spider Map Creation
Explains the usage of spider maps and how to create them.
Posted On: 07/02/2014 06:13 AM
Category: ReportingSpatial
Rating:
How To: Update Values Within A Series Of Text Files
This article touches on updating specific values within a set of text files before actually importing them for analysis.
Posted On: 07/01/2014 04:12 PM
Category: TransformAlteryx EngineInput OutputIn Out
Inspire 2014 - Tips & Tricks!
If you are interested in this year's Tips & Tricks booklet, we now have the pdf available for download!
Posted On: 06/24/2014 03:33 PM
Category: Getting Started with AlteryxAlteryx EngineTips and Tricks
FAQ: Q1 2014 Core Data Bundle Release
Posted On: 06/19/2014 02:15 PM
Category: Demographic Analysis
How To: Create My Own Macros Tool Category In Alteryx 9.0
Custom macros can be a lifesaver in many situations. If you do not have them as part of your toolbox, they can be a bit cumbersome. The fix? Create your own custom tool category ...
Posted On: 06/11/2014 03:31 PM
Category: Alteryx EngineMacros
How To: Prepare a Network Data Install
Do you find yourself running out of space while trying to install the latest Alteryx dataset? Have you considered a network data install to conserve space? There are several reas ...
Posted On: 06/08/2014 11:00 PM
Category: Alteryx EngineInstallation
The Alteryx Analytic Gallery Can Now Handle Zip Files!
Do you utilize a .tab file format for your spatial data? Now you have the ability to upload the .tab suite of files as one single .zip file!
Posted On: 05/21/2014 04:46 PM
Category: AlteryxWebAnalytic Apps macrosAnalytics GalleryAlteryx WebAnalytic Applications
Alteryx 9.0 Tip: Bring Back The Analytic App Interface
Many users that shared analytic apps within an organization would often utilize the Analytic App User Interface. In Alteryx 9.0, we have removed this for a few reasons, but if you ...
Posted On: 05/08/2014 11:40 AM
Category: Analytic Apps macrosTips and TricksAlteryx EngineGetting Started with Alteryx
What's New In Alteryx 9.0: Licensing
Licensing and activation is taking a turn for the better with Alteryx 9.0. We've consolidated a few things to make licensing more robust and easier to use!
Posted On: 04/30/2014 02:49 PM
Category: Getting Started with AlteryxAlteryx EngineLicenses and Activation
What's New In Alteryx 9.0: App & Macro Authoring
One of the most recognizable changes to Alteryx 9.0 is the way you will author Analytic Apps and Macros. Say hello to the new Interface Tools!
Posted On: 04/24/2014 10:37 AM
Category: Getting Started with AlteryxAlteryx EngineAnalytic ApplicationsTips and TricksCommon Use CasesQuick Start Guides
What's New In Alteryx 9.0: An Overview
There are many things that will look familiar in Alteryx 9.0, but there are also many new features. Changes to app and macro authoring, wireless connections, and a host of new con ...
Posted On: 04/24/2014 09:47 AM
Category: Analytic Apps macrosGetting Started with AlteryxAlteryx EngineCommon Use CasesData InvestigationMacrosAnalytic Applications
Using the Dynamic Replace Tool
Ever wonder what those Dynamic Tools are actually used for? Turns out, they may be exactly what you are looking for! In this article, we will cover the Dynamic Replace Tool. In ...
Posted On: 04/15/2014 01:12 PM
Category: GeneralAlteryx EngineDeveloper