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:

Can you add an ExceptionHandler to the Tile Tool? The tool crashed on a large dataset.  I got an Error: Tile (1): No values found before GetMean() on the tile tool. I selected Smar ...
Posted By: sphwillis
Posted On: 03/27/2015 03:52 PM
Comments: 0
Category: Developer
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: 03/27/2015 02:43 PM
Comments: 1
Category: In/Out
Status: Under Review
We need the ability to pre-populate App questions with a default value. This not only gives the user an example of what type of data string the App is looking for, but also may avo ...
Posted By: michael.team
Posted On: 03/27/2015 02:42 PM
Comments: 2
Category: Analytic Appliances
Status: Under Review
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: 03/27/2015 02:42 PM
Comments: 3
Category: Common Use Cases
Status: Not Planned
It would be nice to have the annotations that a user gives a tool with a different background color on the canvas than those tools where the annotation is being automatically popul ...
Posted By: chris_cleckner
Posted On: 03/27/2015 02:41 PM
Comments: 1
Category: Troubleshooting
Status: Under Review
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: 03/27/2015 02:39 PM
Comments: 1
Category: In/Out
Status: Under Review
Hello, 

I am not sure if this capability exists but I assume it does not.

We have a need to optimize a Linear Program (LP) model that consists of a system of equations and has bo ...
Posted By: rlandino
Posted On: 03/27/2015 02:39 PM
Comments: 2
Category: Predictive
Status: Now Available
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: 03/27/2015 02:38 PM
Comments: 2
Category: In/Out
Status: Under Review
It would be good if in the date format option for the Parse tools etc, if there was an option for the 1900 date format used sometimes in Excel/SQL. This is where the date is repres ...
Posted By: kane.glendenning
Posted On: 03/27/2015 02:38 PM
Comments: 1
Category: Parse
Status: Now Available
It would be useful to have the count of rows show up under Browse icons once a module was run.  While debugging, I often have a number of Browse icons scattered about.  It would be ...
Posted By: carl
Posted On: 03/27/2015 02:36 PM
Comments: 2
Category: Preparation
Status: Under Review
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: 03/27/2015 02:35 PM
Comments: 3
Category: Common Use Cases
Status: Under Review
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: 03/27/2015 02:34 PM
Comments: 3
Category: Common Use Cases
Status: Not Planned
90% of the time when dragging in an input tool I need to drag in a select tool to pick only the fields that you want.  Best practice suggests this should be 100% of the time for ef ...
Posted By: chris_cleckner
Posted On: 03/27/2015 02:33 PM
Comments: 1
Category: In/Out
Status: Under Review
If you have either of these situations: 1) a series of dependent database outputs (as in database-supplied auto-incrementing IDs needed for subsequent Inserts/Updates) or 2) writin ...
Posted By: dhilton
Posted On: 03/27/2015 02:29 PM
Comments: 1
Category: In/Out
Status: Planned
I love the new Basic Filter option and it makes writing filters easy/self-expanatory for new users and helps with functions like isnull(). However, I'm almost always writing wh ...
Posted By: joe.lipski
Posted On: 03/27/2015 02:28 PM
Comments: 2
Category: Preparation
Status: Now Available
To keep from being too specific, the "Idea" is that Alteryx Designer should do better at recognizing and handling Date/Times on input. Thoughts include:
 
1) Offer more c ...
Posted By: carl
Posted On: 03/27/2015 02:27 PM
Comments: 2
Category: Preparation
Status: Under Review
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: 03/27/2015 02:27 PM
Comments: 1
Category: Connectors
Status: Under Review
I just had a request from Glenn from BCG to expand our email tool a bit more and allow for outside email services like Gmail and Hotmail. 
Posted By: cmartin
Posted On: 03/27/2015 02:27 PM
Comments: 0
Category: Reporting
Status: Under Review
Can an interactive mapping tool be added as an output tool? 

When reports, files, or tables are generated, it would help to be able to view them on an interactive map.  Currently ...
Posted By: robert_derubeis
Posted On: 03/27/2015 02:25 PM
Comments: 1
Category: Reporting
Status: Now Available
Hi,
Just learnt today that Download Tool doesn't support uploading to a SFTP server. This feature is pretty critical and essential for many use in the Enterprise world. Is this ...
Posted By: hemanth.gangaram
Posted On: 03/27/2015 02:25 PM
Comments: 1
Category: In/Out
Status: Planned
How can I capture the log file location that is created during the module run?  I'd like to use data from the log file in a post run event, but how can I locate the associated ...
Posted By: ben.degiulio
Posted On: 03/27/2015 11:22 AM
Comments: 0
Category: Tips and Tricks
This question is related to the behavior of the Output Data tool.

When creating CSV output with Code Page option set to Unicode UTF-8 the output file contains a byte order sequenc ...
Posted By: ben.stroud
Posted On: 03/26/2015 12:49 PM
Comments: 2
Category: In Out
I'm having quite a bit difficult finding an app on here to gather data by city rather than just radii based on a specific address.  Are there any apps at all here that are capa ...
Posted By: nalee
Posted On: 03/26/2015 08:57 AM
Comments: 1
Category: Demographic Analysis
In-Database Processing FAQ
Click through for an in-depth FAQ around the new In-Database tools!
Posted On: 03/25/2015 03:33 PM
Category: 
XmR / SPC / control charts are a popular format to track data and detect abnormal variations - spikes and trends. Most online examples refer either to dedicated software or Excel t ...
Posted By: charlie.taylor
Posted On: 03/25/2015 05:54 AM
Comments: 0
Category: Preparation
Hello all,

In my work, I am getting input data in key value format, which means one column having all the column names and the other ones having corresponding column values. Basic ...
Posted By: jeeva.ganesan
Posted On: 03/24/2015 01:49 PM
Comments: 2
Category: Transform
Is there an App or how to build an app or suggestions for documenting within the Alteryx project Processing Notes. Such as...

Client Name:

Author:
Creation Date:

Revision Date:
...
Posted By: david_rogers
Posted On: 03/24/2015 01:42 PM
Comments: 0
Category: Tips and Tricks
When I set the width of my columns in my table, it doesn't actually change the width at all. I've tried automatic, percentage, and fixed and nothing changes the width of th ...
Posted By: sh0711
Posted On: 03/24/2015 09:07 AM
Comments: 0
Category: Reporting
I'm trying to load some data from CSV files that have numbers with very high precision.  Due to other reasons, I have to load the data as text fields and then convert it to num ...
Posted By: danielkresina
Posted On: 03/24/2015 07:32 AM
Comments: 9
Category: Alteryx designer
I'm using the input tool to input data from Excel.  The data was in an Excel "TABLE" and only input one record.   Here's what I have tried within Excel in order t ...
Posted By: corinne.milligan
Posted On: 03/20/2015 11:33 PM
Comments: 1
Category: In Out
We need to create a .xlsx output containing count summaries. When running with the full quantity, the output is 40,480 rows. Using the scheduler, the spreadsheet created is empty, ...
Posted By: sandy.pettinger
Posted On: 03/18/2015 02:39 PM
Comments: 0
Category: In Out
I've been able to tweak my settings so that I stop receiving questions, but I would like to modify the settings so it stops automatically sending notifcations to my users as I ...
Posted By: ajwilkin
Posted On: 03/18/2015 11:32 AM
Comments: 0
Category: Analytic Applications
Hello,
I'm trying to build some test applications in the gallery that would read multiple text files as inputs.  On my desktop I just use the * wildcard to read all the files i ...
Posted By: danielkresina
Posted On: 03/18/2015 05:26 AM
Comments: 0
Category: Analytic Applications
Experts, 

I am looking for a way to use SQL temp tables in Alteryx. Traditionally I have been using MS-SQL Server queries to create # tables and then use other join statements sub ...
Posted By: shareth.hariharan
Posted On: 03/18/2015 05:17 AM
Comments: 1
Category: Troubleshooting
Hello!  I'm new to Alteryx.  Does anyone have a clever way of effectively filling down data from x number of rows above?  Similar to the way where you can double-click in excel ...
Posted By: acah
Posted On: 03/18/2015 05:15 AM
Comments: 2
Category: Preparation
We have a group of about 7 artisans that create and publish apps for a user community of about 60. We would like to organize the apps into a few different galleries. We have figure ...
Posted By: ajwilkin
Posted On: 03/17/2015 01:15 PM
Comments: 0
Category: Analytic Applications
This is not a question but simply sharing an expression that it just took me a few minutes to create and I thought I'd share.

Business Problem:
I often download web data using ...
Posted By: jhollingsworth
Posted On: 03/17/2015 07:44 AM
Comments: 0
Category: Tips and Tricks
Hi ,

Can any one explain me how to add additional Experain variables to my dataset using basic fields like State, City, Zip codes.


Thanks in advance.
Posted By: sysinfo
Posted On: 03/16/2015 11:02 AM
Comments: 0
Category: Behavioral Analysis
I have few monthly tasks where the data is refereshed. My Input file is from the Oracle dba and the output file is on my local drive. I would like the output file to be overwritten ...
Posted By: ankush.nayyar
Posted On: 03/15/2015 08:38 PM
Comments: 2
Category: In Out
So I have a huge mess of an email cleaning script that i have decided to clean up and make nice.  It currently uses a bunch of separate Replace Formulas to change common email mist ...
Posted By: jbradshaw
Posted On: 03/13/2015 03:43 PM
Comments: 1
Category: Preparation
Does anyone know how to convert milliseconds to minutes and seconds using the formula tool?
Posted By: lanny.newville
Posted On: 03/13/2015 03:32 PM
Comments: 1
Category: Preparation
Alteryx Core Data Package Variable List
Posted On: 03/05/2015 10:25 AM
Category: Demographics NowDataAll
Q3 2014 Core Data Bundle Release Notes
This article touches on what to expect in the Q3 2014 Core Data Bundle update.
Posted On: 02/26/2015 11:26 AM
Category: 
Alteryx Analytics Gallery - Data Inventory
This will provide a summary of the datasets that are available for use in the Public Gallery and Private Studios, along with a table of current vintages.
Posted On: 02/26/2015 10:31 AM
Category: Analytics GalleryAll
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: 02/18/2015 06:18 AM
Category: GeneralAlteryx serverGetting Started with Alteryx
Filter Using String Data
A few quick tips and tricks on filtering data using string fields.
Posted On: 02/12/2015 09:32 AM
Category: Legal TemplatesData documentation
Alteryx Support Guidelines
Alteryx Inc. is committed to provide technical support, instruction and customer service in order to ensure exceptional customer experience. The following policies and procedures e ...
Posted On: 02/03/2015 03:05 PM
Category: Alteryx server
How To: Get Started With Regular Expressions
Have you ever found yourself attempting to parse or match text, but RegEx seems too complex? It doesn't have to be! Click through for a getting started guide on RegEx in Alteryx.
Posted On: 01/27/2015 04:33 PM
Category: 
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: Analytic Apps macrosData documentationAlteryx EngineGetting Started with Alteryx
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: 
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 EngineAlteryx analytics gallery
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: Products
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: Alteryx analytics galleryAlteryx designerAlteryx serverData documentation
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: 
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: 
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 EngineAll