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:

In-Database Processing FAQ
Click through for an in-depth FAQ around the new In-Database tools!
Posted On: 03/05/2015 11:13 AM
Category: 
Alteryx Core Data Package Variable List
Posted On: 03/05/2015 10:25 AM
Category: Demographics NowDataAll
Hi Folks,

I'm new to Alteryx and not able to figure this one out yet and looking for help/advice.

I've a module that reads from a CSV file , transpose data and save to a ...
Posted By: rkallingal
Posted On: 03/04/2015 10:08 AM
Comments: 0
Category: Analytic Applications
Hi, I've seen some requests lately where the users are requesting maps in  EPS (Encapsulated PostScript) format, which is an Adobe Illustrator file type. If this could be adde ...
Posted By: norman.e.brooks
Posted On: 03/04/2015 09:04 AM
Comments: 0
Category: Reporting
Status: New
Add an option to cancel an occurrence currently queued to run without it removing, or completing, the original schedule. Not sure if this is by design or a bug but when you cancel ...
Posted By: jimmy.romogo
Posted On: 03/03/2015 09:05 AM
Comments: 0
Category: Troubleshooting
Status: New
Is there anything in specific that has to be configured in order to schedule a workflow that is utilizing In-Database tools? Our server does have the In-DB tools license so I dont ...
Posted By: jimmy.romogo
Posted On: 03/03/2015 07:48 AM
Comments: 2
Category: Troubleshooting
We are moving to Alteryx Server Scheduler, but that is causing problems because we run SQL using our Windows NT Integrated security.  Is there a way to let the server know who I am ...
Posted By: tim.allen
Posted On: 03/03/2015 06:26 AM
Comments: 1
Category: Troubleshooting
Hi -

Has anyone encountered this error? We're running Alteryx Designer 9.5 on Windows 7 Desktop. This error is thrown right when the module results the output to an Oracle tab ...
Posted By: arulvelan.subramanian
Posted On: 03/02/2015 08:08 AM
Comments: 1
Category: Troubleshooting
Hi,

Everytime I run a workflow and want to output the data as a Tableau Extract it says it's finished running and exports a 30kb Tableau Extract that cannot be opened (it' ...
Posted By: andrew.downs
Posted On: 02/26/2015 09:22 PM
Comments: 2
Category: In Out
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
Here is a thought I posted about on my Alteryxuser blog: http://alteryxuser.blogspot.com/2015/02/alteryx-and-github-place-for-sharing.html. I interested in hearing your comments!
Posted By: ronh.allaboutgis
Posted On: 02/26/2015 09:01 AM
Comments: 0
Category: Macros
Status: New
This question has been answered for an early version of Alteryx, but version 9.5 appears to require a new answer

The goal is to outptut multiple worksheets into a single Excel /.x ...
Posted By: msking
Posted On: 02/26/2015 12:26 AM
Comments: 1
Category: Common Use Cases
OK.  Say I have a primary table, workorder that tracks units of work being done.  It has a status id value; i.e., open/closed/dispatched, whatever.  Secondarily, I have a history t ...
Posted By: brian.scott
Posted On: 02/26/2015 12:06 AM
Comments: 2
Category: Transform
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: 02/24/2015 04:39 PM
Comments: 1
Category: Preparation
In recent months a new global app was added to allow the monitor of activity on an application. This is a great start but more details would make tracking a lot easier for our comp ...
Posted By: cmagill
Posted On: 02/24/2015 05:59 AM
Comments: 0
Category: Reporting
Status: New
I have a field with with multiple string separated by the ; symbol
Row 1: ca; do; ho;
Row 2: be; do
Row 3: ca; ho

I assign a Record ID to each row and then break of the string and ...
Posted By: david_rogers
Posted On: 02/23/2015 08:06 AM
Comments: 3
Category: Tips and Tricks
I'm using .sv file format for compressing large files and using them in Alteryx.  .sv is call a Alteryx Spatial Zip file.  This format seems to offer the highest level of compr ...
Posted By: gilbert.2.carmichael
Posted On: 02/21/2015 10:30 AM
Comments: 0
Category: In/Out
Status: New
Im trying to create a concave hull with a group of polygons.These polygons arent touching. I am trying to create an overall boundary but keeping the basic shape. Any Ideas?
Posted By: tyler.sassara
Posted On: 02/20/2015 01:44 PM
Comments: 3
Category: Troubleshooting
Would be nice to have the option of disabling the append of the "action" to the variable in the summarize tool.  Sometimes it's useful to leave the variable name as i ...
Posted By: chris_cleckner
Posted On: 02/19/2015 10:34 AM
Comments: 0
Category: Data Investigation
Status: New
Make it easier to use Delete and connect around 

ex: Shift + Delete
Posted By: strauss.benjamin
Posted On: 02/19/2015 07:44 AM
Comments: 0
Category: Common Use Cases
Status: New
Hi Team,
I am getting error while trying to connect HDFS using HDFS Input connector in Alteryx Designer. Please help me to resolve this.

 
Posted By: balarampanda
Posted On: 02/19/2015 12:21 AM
Comments: 1
Category: Pricing
I would love to have alteryx dump the excess amount of records on a new sheet in the same excel file that the user creates for dumping the output.
Posted By: victor.chowdhury
Posted On: 02/18/2015 10:58 AM
Comments: 0
Category: In/Out
Status: New
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
Would be nice to have a place where general use macros or packages could be published by the community and then used within the designer.

Thinking of something along the lines of  ...
Posted By: jdunkerley
Posted On: 02/18/2015 01:46 AM
Comments: 0
Category: Macros
Status: New
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: 02/17/2015 10:59 AM
Comments: 2
Category: Preparation
Status: New
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: 02/17/2015 10:54 AM
Comments: 0
Category: Reporting
Status: New
I have daily data come in and need to make one of the columns the filename.  i.e. reach record in the table would have "todaysfile_02162015.txt" or whatever the file name ...
Posted By: david_rogers
Posted On: 02/17/2015 09:01 AM
Comments: 2
Category: Tips and Tricks
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: 02/14/2015 08:08 AM
Comments: 1
Category: Macros
Status: Now Available
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: 02/14/2015 08:03 AM
Comments: 0
Category: Reporting
Status: Planned
Pulling data down from Salesforce takes a looong time. It would be a great feature to be able to cache this, similar to how 9.5 added database caching.
Posted By: slutz
Posted On: 02/13/2015 02:07 PM
Comments: 1
Category: Connectors
Status: 
  I have had a number of requests for Alteryx to provide XML as an output format. It would be great to have configuration settings to allow for just text based output:
<Row ID ...
Posted By: slutz
Posted On: 02/13/2015 02:05 PM
Comments: 0
Category: In/Out
Status: 
I have a DateTime field.  The current format is 2015-02-02 00:00:00.  I simply want to pull from this date the month in a string format.  The answer should be 2.  I'm sure it&# ...
Posted By: david_rogers
Posted On: 02/13/2015 12:12 PM
Comments: 3
Category: Tips and Tricks
Problem: When you configure fields manually in the union control and then go back to remove a field it throws up an error that "XYZ field missing"
Solution: One needs to ...
Posted By: victor.chowdhury
Posted On: 02/13/2015 11:04 AM
Comments: 0
Category: Join
Status: New
I have a bunch of records that belong to groups, with a field assigning the group.  I.e. field name is "Group Name" and then each record has something like "Group 1& ...
Posted By: jbradshaw
Posted On: 02/12/2015 07:10 PM
Comments: 1
Category: Preparation
I daily receive a list of companies.  Some of these need to be removed if they have certain words in them, like the word "Overland".  My list is about 75 words long. Is t ...
Posted By: david_rogers
Posted On: 02/12/2015 02:42 PM
Comments: 2
Category: Macros
I have a bunch of records that belong to groups, with a field assigning the group.  I.e. field name is "Group Name" and then each record has something like "Group 1& ...
Posted By: jbradshaw
Posted On: 02/12/2015 10:00 AM
Comments: 0
Category: Preparation
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
Correct me if I am wrong, when I use the trade area tool, the only non-spatial data appended to my input dataset is the RadiusSize field. Can this be expanded to include the Units ...
Posted By: sphwillis
Posted On: 02/11/2015 06:16 PM
Comments: 0
Category: Spatial
Status: New
I have a list that has duplicates. For example my list is (A, B, C, A, A, D, E)
I want to be able to seperate all of the A's from the list to get (B, C, D, E) and (A, A, A) 

U ...
Posted By: njkm
Posted On: 02/11/2015 05:36 PM
Comments: 4
Category: Common Use Cases
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: 02/11/2015 03:12 PM
Comments: 0
Category: In/Out
Status: New
It would be very powerful to be able to multi-thread batch macros. Since the data for each batch is known and unrelated between batches, it seems like the processing of each batch ...
Posted By: dhilton
Posted On: 02/11/2015 02:32 PM
Comments: 1
Category: Macros
Status: New
I would like to obtain major stats for the US population on Experian variables or any other data package. I have used the calgary node cross count node but the results don't ap ...
Posted By: paolo.carbone
Posted On: 02/11/2015 06:59 AM
Comments: 0
Category: Calgary
I'm using the Linear Regression tool and would like to continue to use some of it's output. Specifically, fields from the coefficients table such as intercept. Is there a w ...
Posted By: mdoo
Posted On: 02/11/2015 04:03 AM
Comments: 1
Category: Predictive
The tabs for the Workflow-Configuration sheet has the Canvas tab as the first one and defaults back to the Canvas tab after running.  I want to be able to have the Workflow tab be ...
Posted By: kenneth.s.buck
Posted On: 02/09/2015 09:19 AM
Comments: 0
Category: Common Use Cases
Status: New
Created an application on twitter. Got the Consumer Key and Secret. Still getting an error. Does anyone know what I am missing?

Posted By: mreinsch
Posted On: 02/09/2015 07:49 AM
Comments: 0
Category: Macros
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