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:

It would be helpful to have a unique feature within Calgary in order to return a unique count or a data extract. The current Crss count will error if there are two many rows.
Posted By: mrottinghaus
Posted On: 01/23/2015 11:08 AM
Comments: 0
Category: Calgary
Status: New
It would be extremely helpful if Alteryx could add quick filters to the data browsing windows that would allow you to filter the contents of the window based on each column.  Essen ...
Posted By: dustin
Posted On: 01/23/2015 08:48 AM
Comments: 3
Category: In/Out
Status: New
Dear Alteryx Team

A nice to have :
Possibility to create output directories automatically using a given fieldname in order to organize properly macros outputs

Thanks a lot

Arno
...
Posted By: arnaud.langlois
Posted On: 01/23/2015 05:49 AM
Comments: 0
Category: Macros
Status: New
http://community.alteryx.com/Data-Blending/In-Out/Error-Output-Data-37-OutboundNamedPipeWriteFile-The-pipe-is-being-closed
The person who opened this case simply ended it with that ...
Posted By: colleen.s.fresh
Posted On: 01/22/2015 12:15 AM
Comments: 1
Category: Troubleshooting
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: 01/20/2015 11:24 AM
Category: Quick Start GuidesGetting Started with AlteryxGeneral
Rating:
Let's say my source data set has a characteristics table attached to my primary table; i.e., 

person == primary table with person identifier, name.
person_phone == one to many ...
Posted By: brian.scott
Posted On: 01/20/2015 07:46 AM
Comments: 3
Category: Join
Alteryx Technical Overview, August 2014
Looking for an overview of all the technical capabilities Alteryx has? This August 2014 article highlights a recently released document that covers your questions!
Posted On: 01/19/2015 01:34 PM
Category: 
Alteryx 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: 01/19/2015 01:30 PM
Category: Alteryx EngineGetting Started with AlteryxAnalytic Apps macrosTips and Tricks
Rating:
Hi,

I am using ODBC Connection to connect with Redshift and I have noticed that the write queries are horribly slow. It takes around 10 minutes to load 11K records into a redshift ...
Posted By: aakarsh.kalra
Posted On: 01/19/2015 11:39 AM
Comments: 3
Category: In Out
I love the new 9.5 Filter tool interface.  Very simple to create filters!

A simple addition could be to add an "And" and "Or" button next to the wizard so we c ...
Posted By: strauss.benjamin
Posted On: 01/19/2015 10:37 AM
Comments: 1
Category: Preparation
Status: Under Review
Have the ability to see the data with the browse tool by simply clicking the component we want in the workflow.
The browse tool becomes a default property and not a component we ha ...
Posted By: julien.boulenger
Posted On: 01/19/2015 10:35 AM
Comments: 2
Category: Common Use Cases
Status: Planned
I have a strong feeling Alteryx doesn't handle ascii control character End of medium (EM) when writing to an excel sheet. Created an unreadable excel file. However if you write ...
Posted By: adrian.boeh
Posted On: 01/19/2015 10:31 AM
Comments: 1
Category: In/Out
Status: New
Alteryx 9.5 - What's New?
Starting out 2015 with a big release! Alteryx 9.5 has just been unveiled, sporting new in-database processing functionality, new MS Excel drivers and a few functionality enhancemen ...
Posted On: 01/16/2015 03:41 PM
Category: 
Currently there are bulk loaders within alteryx for Teradata, Oracle and SQL Server.
It would be great to have a bulk loader for AWS Redshift in order to fully industrialize the wo ...
Posted By: adrian.loong
Posted On: 01/16/2015 03:52 AM
Comments: 2
Category: In/Out
Status: New
I would like to do web mapping and I couldn't find this Web Mercator projection in Alteryx. Where can I find it or is this projection called differently in Alteryx? If it doesn ...
Posted By: sphwillis
Posted On: 01/15/2015 03:37 PM
Comments: 3
Category: Spatial
Does the new "Connect In-Database" tool allow for a 32-bit Oracle connection? 

Thanks!
Anne 
Posted By: amerna
Posted On: 01/15/2015 02:57 PM
Comments: 0
Category: In Out
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: 01/15/2015 11:43 AM
Comments: 0
Category: Preparation
Status: Under Review
I am have some issues get the order of execution correct. I have 5 files that are read in using a Alteryx App., Later in the flow I ahve a run command that moves the files to an Ar ...
Posted By: alteryx
Posted On: 01/13/2015 01:24 PM
Comments: 3
Category: Analytic Applications
In the Gallery, when reviewing the results of a recently run app, the option to save the results to Dropbox is currently an option.  This is a great, however, the only file format ...
Posted By: collin.pace
Posted On: 01/13/2015 08:15 AM
Comments: 0
Category: Reporting
Status: New
I love this option in the Input Tool and use it extensively. It would be really handy to have the ability to set this option 'globally' for all Inputs in a module. I don ...
Posted By: tom.montpool
Posted On: 01/13/2015 06:00 AM
Comments: 0
Category: In/Out
Status: New
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: 01/12/2015 10:15 AM
Comments: 1
Category: Data Investigation
Status: Coming Soon
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: 01/12/2015 08:21 AM
Comments: 4
Category: Join
Hello -

I am working on an app that will allow users to automatically run some complex summaries based on response data. Essentially I want to turn Exibit A into Exibit B. If the ...
Posted By: ajwilkin
Posted On: 01/12/2015 07:13 AM
Comments: 2
Category: Transform
Hi,

I've used Alteryx since few months and when I use oci connector with an encrypted password, It's not possible to change it (change dev-database to production-database) ...
Posted By: michael.breion
Posted On: 01/12/2015 04:29 AM
Comments: 2
Category: Developer
I need to use Alteryx on a new PC, but I can't register the product on this PC, even though I have deactivated the license on the old PC.
I'm told that there are "No m ...
Posted By: jaris.somod
Posted On: 01/09/2015 08:47 AM
Comments: 1
Category: Licenses and Activation
For me to leverage the Email tool, I need to authenticate the SMTP so the server recognizes who I am.  Currently, Alteryx does not have a way to authenticate the SMTP so this tool ...
Posted By: brian2.newman
Posted On: 01/09/2015 06:17 AM
Comments: 0
Category: Documentation
Status: New
Hello,

Has anyone had any experience in reading modules to gather source and target information on the data fields being used. Im looking to create an automated way to log input f ...
Posted By: shane
Posted On: 01/08/2015 02:45 PM
Comments: 0
Category: Reporting
test
Posted By: nick
Posted On: 01/08/2015 02:05 PM
Comments: 1
Category: Reporting
It would be great if you could select multiple Data Fields in a single Crosstab

For example. I would like to SUM (Methodology) Pet Food Sales (Data Field 1) & Baby Food Sales ...
Posted By: ajwilkin
Posted On: 01/08/2015 12:39 PM
Comments: 3
Category: Common Use Cases
Status: New
It would be great if there was an option to delete an expected column from a select tool. Sometimes I have to do a lot of work to rename different columns and would love to be able ...
Posted By: ajwilkin
Posted On: 01/08/2015 12:28 PM
Comments: 3
Category: Common Use Cases
Status: New
I'm looking to add records to an alteryx database each week from another data source. One way would be to create a new yxdb each week, but that doesn't seem like the best o ...
Posted By: avoel
Posted On: 01/08/2015 02:23 AM
Comments: 3
Category: Documentation
Can someone from Alteryx give some advanced tips and tricks on App performance

I am wondering if keeping browse tools/ enabling connection progress has a negative effect on App pe ...
Posted By: sphwillis
Posted On: 01/07/2015 11:37 AM
Comments: 0
Category: Tips and Tricks
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: 01/07/2015 07:00 AM
Comments: 1
Category: Common Use Cases
Status: Under Review
You can select all fields at once, but it'd be nice to select a chunk of fields using CTL+Shift+Click
Posted By: mbarone
Posted On: 01/07/2015 06:33 AM
Comments: 0
Category: Common Use Cases
Status: Under Review
It would be great if we could output the coefficients of regression equation to a table so that one can use them in rest of the module. Currently, Alteryx can output the table/coef ...
Posted By: rahuls
Posted On: 01/07/2015 06:33 AM
Comments: 1
Category: Predictive
Status: Under Review
This is something small and silly, but having a comma in the number of records shown on the output window would be very helpful!
Posted By: kristic
Posted On: 01/07/2015 06:31 AM
Comments: 0
Category: In/Out
Status: Under Review
Similar to how the Tool Container Defaults can be set on the Document tab of User Settings, it would be nice to be able to set the Comment box defaults here as well. I find that I ...
Posted By: kane.glendenning
Posted On: 01/07/2015 06:25 AM
Comments: 0
Category: Documentation
Status: Under Review
Hi,

I noticed some inconsistent behavior while using DecompseUnicdoeForMatch() function. In my input excel files there are some foriegn characters which i want to get rid of, when ...
Posted By: aakarsh.kalra
Posted On: 01/06/2015 09:30 AM
Comments: 1
Category: Transform
Both Input and Output tools should have the ability to read or write any file type from/into standard compression types (ZIP and GZIP). This would be helpful when managing large fi ...
Posted By: dhilton
Posted On: 01/06/2015 08:27 AM
Comments: 3
Category: In/Out
Status: Under Review
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: 01/05/2015 03:13 PM
Comments: 2
Category: In Out
Transferring A License With Alteryx v9.1 And Above
Are you getting a PC upgrade for your Alteryx development? Now licenses can be uninstalled and reinstalled from one machine to the other! Click through for more details.
Posted On: 01/05/2015 12:03 PM
Category: Alteryx EngineLicenses and Activation
Hi,

How do I convert the date coloumn to date currently alteryx does not recognize it as such?
    RecordID    medium    country    date    transactionRevenue    transactions
1   ...
Posted By: msh
Posted On: 01/05/2015 08:24 AM
Comments: 1
Category: Troubleshooting
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/22/2014 09:17 AM
Comments: 2
Category: Quick Start Guides
Is there any way to compress data in LAteryx?  I am working with large data sets and really need to compress the data for output.
Posted By: kmcdowell
Posted On: 12/20/2014 08:39 PM
Comments: 3
Category: In Out
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
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: 
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: 
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:
R Tool: Predictive Analytics
WebEx session on basics for Alteryx R Tool
Posted On: 08/12/2014 11:26 AM
Category: MacrosPredictive
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 AlteryxInstallationDataAddressAlteryx Engine
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: TroubleshootingInput OutputAlteryx EngineDataIn Out
Rating: