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:

Hi,

We were recently asked by our IT Department how many modules can Alteryx server run simultaneously?

I have seen jobs go into the queue but have not tested running simultaneou ...
Posted By: rlandino
Posted On: 12/19/2014 01:47 PM
Comments: 1
Category: Reporting
I'm making my way through the tutorial and in the Blending Data page, I don't understand how in step 3/4 the Smart Tile 'knew' to pick the 'Visits' field wi ...
Posted By: randy
Posted On: 12/19/2014 01:36 PM
Comments: 0
Category: Quick Start Guides
Where can I find the sample data for the Alteryx Tutorials (built in tutorials)? I looked where it says it is installed but the folder is empty.
Posted By: alteryx
Posted On: 12/19/2014 12:51 PM
Comments: 1
Category: Installation
Scenario:  6 input tools, and want to add, say, a select tool after each one.
Would be nice to select all 6, and add the tool after all of them at once.
Posted By: mbarone
Posted On: 12/19/2014 05:03 AM
Comments: 0
Category: Common Use Cases
Status: New
Is it possible to have certain nodes selected when reading a custom xml file in the tree tool? So I would like to see certain nodes with checkbox turned on in the Tree tool. I see ...
Posted By: sphwillis
Posted On: 12/18/2014 01:17 PM
Comments: 3
Category: In Out
I would like to use the precreate statement as part of a app. That means if a user selects ID '12345' from an interface tool, I would like to delete recs in SQL server with ...
Posted By: sphwillis
Posted On: 12/17/2014 09:07 AM
Comments: 1
Category: In/Out
Status: New
I would like to be able to use the join tool to join on inequalities.  We could join two tables, A and B on A.value is >= B.value1 AND A.value <= B.value2.  This would replic ...
Posted By: matthew.slaughter
Posted On: 12/16/2014 08:40 AM
Comments: 0
Category: Join
Status: New
Probably a small request, but please consider updating the Output and Browse tool icons so they are easier to tell apart from one another.

When working with large modules, I often ...
Posted By: michael.team
Posted On: 12/16/2014 08:03 AM
Comments: 2
Category: In/Out
Status: Coming Soon
Possibility to deselect fields directly in the input (shape, csv, tab, etc).

 
Posted By: alteryx
Posted On: 12/16/2014 07:19 AM
Comments: 1
Category: In/Out
Status: Under Review
Hi ,
Today i stuck in one position where my current module gaves an error because it doesnt found the Fields name. I define the field name in Formula tool for validation and harmon ...
Posted By: ashiques
Posted On: 12/16/2014 07:13 AM
Comments: 1
Category: Transform
Status: Now Available
Can you add some additional options to the running sum tool?  I know this can be done in the Multi-Row formula, but it just takes too long to program and Alteryx is designed for sp ...
Posted By: sean.otto
Posted On: 12/16/2014 07:12 AM
Comments: 2
Category: Transform
Status: Under Review
I have summary data that has counts of people by towns along with demographic and other  data for those towns.  How can Alteryx be set up to do clustering to group towns with simil ...
Posted By: j_brzezinski
Posted On: 12/15/2014 10:54 AM
Comments: 1
Category: Demographic Analysis
Has anyone gotten this error?  I cannot figure out what is going on with the App, my module is working fine.  
Posted By: alteryx
Posted On: 12/12/2014 03:53 PM
Comments: 2
Category: Troubleshooting
All of the below is happening with a connection to a Postgres DB.

Alteryx is giving a "No Columns Returned" error on sql that executes when run within pgAdmin. (Code bel ...
Posted By: rmarshall
Posted On: 12/12/2014 09:57 AM
Comments: 0
Category: Troubleshooting
Wouldn't it be nice to have more training examples available on YouTube?
Posted By: mark.frisch
Posted On: 12/12/2014 09:01 AM
Comments: 1
Category: Tips and Tricks
Status: Now Available
Hi everyone - 

Edit:  It looks like I got this to work by putting blockers on all three outputs from the join and ordering my operations from top to bottom as delete and append/ap ...
Posted By: brian.scott
Posted On: 12/12/2014 07:22 AM
Comments: 2
Category: Developer
hi

I need to run an app on a fixed frequency and schedule. I know we can do it from designer. Is there a way we can schedule this app via Alteryx gallery? 
Posted By: rahuls
Posted On: 12/11/2014 11:25 PM
Comments: 1
Category: Analytic Applications
It would be great if the admin could change some default settings on the Alteryx Gallery page. For example, where we have the list of apps, show Detail view and sort by App name as ...
Posted By: sphwillis
Posted On: 12/11/2014 04:04 PM
Comments: 0
Category: Common Use Cases
Status: Under Review
Can you add the Data Output along with the Report Output on the Association Analysis tool.  

We needed to manually change this on our end but it would be nice if in 9.5 this easy ...
Posted By: strauss.benjamin
Posted On: 12/11/2014 03:59 PM
Comments: 1
Category: Data Investigation
Status: Under Review
It would be extremely helpful to add in a "Count Distinct" function into the summarize tool.  This would help tremendously when working with hierarchical data.
Posted By: chris_cleckner
Posted On: 12/11/2014 03:49 PM
Comments: 1
Category: Data Investigation
Status: Coming Soon
With a module that contains a lot of tool containers, it would be nice to have an option (similar to Disable All Tool That Write Output in the RunTime TAB) to disable all Tool Cont ...
Posted By: brian.wiedower
Posted On: 12/11/2014 03:45 PM
Comments: 1
Category: Tips and Tricks
Status: Under Review
Currently if I receive a file where fields are empty rather than Null(), the summarize won't count them with the CountNull option. Fairly easy to put a formula right before whe ...
Posted By: brian.wiedower
Posted On: 12/11/2014 03:44 PM
Comments: 2
Category: Transform
Status: Now Available
Hi,

Instead of having multiple filters to create mutliples new branches for downstream analysis, Alteryx should have one filter with multiples ouputs ports. Each filter would is o ...
Posted By: alteryx
Posted On: 12/11/2014 03:43 PM
Comments: 0
Category: Preparation
Status: Under Review
I'm working on loading some public data available as an .xls doc on the web. I can use the download tool to fetch the file, but then have to save it, and reopen it in a separat ...
Posted By: ercs
Posted On: 12/11/2014 03:42 PM
Comments: 0
Category: Parse
Status: Under Review
Rather than giving the users a big list of different date formats to choose from, allow the user to construct their own format with syntax of the incoming date that they are dealin ...
Posted By: strauss.benjamin
Posted On: 12/11/2014 03:41 PM
Comments: 0
Category: Preparation
Status: Under Review
Macro Debugging: Use Another Macro!
Do you develop custom macros using Alteryx? Try the X-Ray Macro to help with debugging!
Posted On: 12/11/2014 03:11 PM
Category: 
Hi everyone - 

New guy here in case I'm missing something easy.  Anyways, I've developed six or seven .yxmds that feed into a common dataset.  I'm not a server level u ...
Posted By: brian.scott
Posted On: 12/10/2014 08:37 AM
Comments: 2
Category: Common Use Cases
Does Alteryx support the unsigned int database type? I'm seeing some strange behavior for unsigned ints above the 2147483647 limit for a signed int and I don't see any way ...
Posted By: jgreene
Posted On: 12/05/2014 02:58 PM
Comments: 5
Category: Troubleshooting
Hi all,

Alteryx is relatively new to me - so excuse me if this is a stupid question.

Currently the only data I have input has come from data extracts (CSV).

I have just been ask ...
Posted By: david.crelley
Posted On: 12/05/2014 12:25 PM
Comments: 1
Category: In Out
I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields.  Currently they are not recognized as spatia ...
Posted By: brian.wiedower
Posted On: 12/05/2014 11:58 AM
Comments: 1
Category: In/Out
Status: New
Hi ,

I have a file in which I have to add a new field "Index2" . So I used the Formula tool and wrote  "IF [Index] == '5' and [Index] == '5.1' THEN ...
Posted By: ashiques
Posted On: 12/05/2014 01:03 AM
Comments: 3
Category: Join
Hi, Alteryx expect,

I have a need to insert two carriage return for a long string into new lines when seeing  special characters, for example my current string is:"index1 is ...
Posted By: wendy.lu
Posted On: 12/04/2014 11:53 AM
Comments: 3
Category: Preparation
Hi, I'm searching for a way to simply execute generic SQL commands against a server.  Specifically, I'd like to execute some stored procedures on the server after loading d ...
Posted By: dustin
Posted On: 12/04/2014 08:44 AM
Comments: 2
Category: Developer
On The Engine Works blog (linked below) I read that I can create my own Allocate Virtual Variables - using a wizard to boot! However, I cannot find any more references to these All ...
Posted By: sarah.thompson
Posted On: 12/03/2014 09:57 AM
Comments: 0
Category: Documentation
Hi All,

This is my file in which i have multiple rows in Product Hierarchy in which i have to calculate that SG == Sum of all MF. Particular MF == Sum of Particular B(Brand). & ...
Posted By: ashiques
Posted On: 12/02/2014 09:33 PM
Comments: 1
Category: Transform
Logistic regression tool models the probability of an event with a single outcome (yes/no).  What if there are several outcomes?  The model would produce the probability of each ou ...
Posted By: j_brzezinski
Posted On: 12/01/2014 03:58 PM
Comments: 1
Category: Predictive
Hi

Can anyone tell me that how many fields can be goes in to excel by ALteryx output.
Like i have 570 field but my Module doesnt create the Excel file it have an error. "Erro ...
Posted By: ashiques
Posted On: 12/01/2014 12:12 PM
Comments: 1
Category: In Out
Hello Alterxy Users! 

I've got a freebie license with an external vendor that will give me data back in .xml format that I need to consume daily.  Unfortunately, because I' ...
Posted By: brian.scott
Posted On: 12/01/2014 11:58 AM
Comments: 2
Category: Common Use Cases
Hello,

I think it would be extremely useful to have a switch connector available in Alteryx. What I mean by a switch connector is a connecting line with an on/off state that will ...
Posted By: aduplessie
Posted On: 11/17/2014 07:04 AM
Comments: 3
Category: Connectors
Status: New
Hello,

I think it would be extremely useful to have a switch connector available in Alteryx. What I mean by a switch connector is a connecting line with an on/off state that will ...
Posted By: aduplessie
Posted On: 11/17/2014 07:04 AM
Comments: 0
Category: Connectors
Status: New
We've had several requests from clients for the ability to import password protected Excel spreadsheets into Alteryx.  Within Alteryx, it would be good to specify the password ...
Posted By: cbradbrook
Posted On: 11/13/2014 09:45 AM
Comments: 0
Category: In/Out
Status: New
How To: Optimize Your Modules
In Client Services, we often get questions about whether or not a module has been optimized for efficiency. When we get these questions, there are a few review items we begin with ...
Posted On: 11/04/2014 03:48 PM
Category: Getting Started
Rating:
Alteryx Command Line Silent Install
Command line options are provided for IT departments or users wanting to install Alteryx without the need for user intervention.
Posted On: 11/03/2014 07:04 AM
Category: Licenses and ActivationInstallationQuick Start GuidesTips and Tricks
Rating:
Q2 2014 Core Data Bundle Release Notes
This article touches on what to expect in the Q2 2014 Core Data Bundle update.
Posted On: 10/23/2014 01:02 PM
Category: 
Latest Alteryx Customer Advisory e-Forum Recording Now Available!
Click through for the latest Alteryx Customer Advisory e-Forum recording from October 7, 2014.
Posted On: 10/09/2014 04:29 PM
Category: 
2014 Shipping and Gallery Data Update Schedule
Posted On: 10/03/2014 03:02 PM
Category: 
Getting Started with Alteryx
We’ve developed this handy Customer Success Playbook to ensure success throughout your lifecycle with our powerful Alteryx technology. The following document outlines the stages an ...
Posted On: 09/24/2014 02:48 PM
Category: GeneralGetting Started with AlteryxQuick Start Guides
Rating:
What's New In Alteryx 9.1: An Overview
With the recent release of Alteryx 9.1, we've implemented a few new features, enhancements, and bug fixes that will help to increase the reliability and speed of Alteryx!
Posted On: 09/24/2014 01:52 PM
Category: 
Rating:
Can Alteryx Run On A Mac?
On occasion we get support calls asking if Alteryx can run on a Mac. The short answer is "no", with one caveat! It is possible to run Alteryx on a Mac through a virtual machine ( ...
Posted On: 09/17/2014 12:56 PM
Category: 
Rating:
Does Latitude And Longitude Precision Matter?
In Client Services, we often get geography related questions that revolve around precision and accuracy of points or trade areas created in Alteryx. The real question is how accur ...
Posted On: 09/10/2014 10:56 AM
Category: Alteryx EngineSpatialAddress
Rating:
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: 
Rating:
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: 
R Tool: Predictive Analytics
WebEx session on basics for Alteryx R Tool
Posted On: 08/12/2014 11:26 AM
Category: PredictiveMacros
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
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: Getting Started with AlteryxInstallationDataAlteryx EngineAddress
Rating:
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: Input OutputTroubleshootingDataIn OutAlteryx Engine
Rating:
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: Input OutputTransformAlteryx EngineIn Out