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:

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
Right now we can create Tableau extract files (.tde), but cannot read them into Alteryx -- this limits the partnership of these two companies.
Please add the functionality to impor ...
Posted By: jeremy.dalletezze
Posted On: 08/22/2014 09:14 AM
Comments: 0
Category: In/Out
Status: New
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
Currently, the map input for an application defaults either to a global view of the United States or to a fixed boundary. Usng a chained application, it would be an extremely usefu ...
Posted By: paul
Posted On: 08/20/2014 02:29 PM
Comments: 0
Category: Analytic Appliances
Status: Under Review
  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: PredictiveMacros
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
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/12/2014 05:56 AM
Comments: 1
Category: Developer
Status: New
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
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/06/2014 06:28 AM
Comments: 0
Category: Preparation
Status: New
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
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/05/2014 01:50 PM
Comments: 1
Category: Developer
Status: New
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
UPDATE: The below was manifest when running within Parallels VM on my Mac .. when I ran on a PC the speed is much more comparable between the native R IDE and Alteryx, which is goo ...
Posted By: gioel.molinari
Posted On: 08/05/2014 10:02 AM
Comments: 2
Category: Developer
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
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: 08/04/2014 08:53 AM
Comments: 5
Category: Developer
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/04/2014 08:49 AM
Comments: 0
Category: Reporting
Status: New
I have a file of Stores, the Counties were their customers live and the count of their customers in the county (Store, County, Count), and I need to find the Counties that  cover 8 ...
Posted By: larrysanchez
Posted On: 08/04/2014 07:14 AM
Comments: 2
Category: Tips and Tricks
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/01/2014 01:58 PM
Comments: 1
Category: Preparation
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: 07/31/2014 10:09 AM
Comments: 0
Category: Preparation
Status: New
I have often thought it would be nice to have a 'predicted run time' for a module calculated.

An adequate prediction might be the complete run time last time the module ra ...
Posted By: elanser
Posted On: 07/31/2014 06:13 AM
Comments: 0
Category: Tips and Tricks
Status: New
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
Hi,

I am a new user.  When I have warnings during a run, how do i see those warnings?  Looks like there is some out put setting for a log file.  Can anyone help me do this setting ...
Posted By: mani.vannan
Posted On: 07/29/2014 12:28 PM
Comments: 1
Category: Tips and Tricks
Hello, this is my first post in the Alteryx community and I am super new.

I am looking to parse a series of Text files from Opensecrets.org

Each file is in .txt format, with comm ...
Posted By: nhara
Posted On: 07/29/2014 09:04 AM
Comments: 3
Category: Parse
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: 07/29/2014 08:29 AM
Comments: 0
Category: Macros
Status: New
Hi

I need to copy a file from one server to another and then process the file . Is there a way to do it?

Thanks
Posted By: evelyn.sherwin
Posted On: 07/29/2014 06:30 AM
Comments: 2
Category: Preparation
Is there a way to use Detour in a programmatic way? I would like to bypass a set of tools if a condition in my data is met. For example, bypass a Sort in a Macro if the count of re ...
Posted By: gioel.molinari
Posted On: 07/28/2014 08:10 PM
Comments: 3
Category: Tips and Tricks
I'd love the ability to Input an already-formatted Print Layout area within an Excel document, or a .PDF document in an effort to standardize reports needed on a regular basis. ...
Posted By: jalbertini
Posted On: 07/22/2014 06:40 AM
Comments: 1
Category: In/Out
Status: New
I'd love the ability to Input an already-formatted Print Layout area within an Excel document, or a .PDF document in an effort to standardize reports needed on a regular basis. ...
Posted By: jalbertini
Posted On: 07/22/2014 06:40 AM
Comments: 0
Category: In/Out
Status: New
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: Alteryx EngineDataInput OutputTroubleshootingIn Out
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: 07/21/2014 08:11 AM
Comments: 0
Category: Calgary
Status: New
When developing a module, I generally BROWSE the final data until I'm ultimately ready to generate output.  Then I need to add or replace a browse tool with an output tool.  Pe ...
Posted By: mark.frisch
Posted On: 07/21/2014 08:01 AM
Comments: 0
Category: In/Out
Status: New
In my environment, creating tables with fields in a particular order is a requirement.

The Select tool (and others) let me manually change sort orders. The Select tool will also a ...
Posted By: tom.montpool
Posted On: 07/18/2014 09:16 AM
Comments: 2
Category: Common Use Cases
Status: New
I got to know that in version 9.1 Alteryx will have Unique Tool with "Unknow"check box to make it dynamic. I want to suggest same logic for Summarize tool for making it D ...
Posted By: pratikg
Posted On: 07/17/2014 09:31 AM
Comments: 0
Category: Developer
Status: New
In the Browse window: Can we add a Find function like in excel? (e.g. find record_ID==4 or name =='foobar') Can we click the column name so it sorts on that field? I ...
Posted By: sphwillis
Posted On: 07/16/2014 09:56 AM
Comments: 0
Category: Common Use Cases
Status: New
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: 
Our team works with a lot of in-house transaction data sets that have been put into a calgary database.  It would be much easier to build apps that use the calgary input tool witho ...
Posted By: chris_cleckner
Posted On: 07/08/2014 06:07 AM
Comments: 0
Category: Analytic Appliances
Status: New
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: 07/08/2014 05:59 AM
Comments: 0
Category: Analytic Appliances
Status: New
Add an option to read directly from a zip file.
Posted By: joe.strellis
Posted On: 07/08/2014 01:23 AM
Comments: 1
Category: In/Out
Status: New
It would be nice to have the ability to double click the top area of a container to either show or hide the container's objects. Only being able to show or hide containers usin ...
Posted By: brian.kasen
Posted On: 07/02/2014 01:47 PM
Comments: 0
Category: Tips and Tricks
Status: New
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: Input OutputAlteryx EngineTransformIn 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 AlteryxTips and TricksAlteryx Engine
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 macrosAnalytic ApplicationsAlteryx WebAnalytics Gallery
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: Getting Started with AlteryxAnalytic Apps macrosAlteryx EngineTips and Tricks
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: Alteryx EngineGetting Started with AlteryxLicenses 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 EngineQuick Start GuidesCommon Use CasesTips and TricksAnalytic Applications
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 macrosAnalytic ApplicationsMacrosData InvestigationCommon Use CasesAlteryx EngineGetting Started with Alteryx
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: DeveloperAlteryx EngineGeneral
My Salesforce Connector Is No Longer Working, What Do I Do?
Did your module or app using the Salesforce Connector tool suddenly stop working? Salesforce just updated their API, which ultimately changed the way our Salesforce Connector tool ...
Posted On: 04/08/2014 01:02 PM
Category: Input OutputAnalytic Apps macrosAlteryx EngineConnectors