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:

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: 
I have a situation where data has been loaded into a SQL database from csv files. There was no ID on either side and I need to know which records have already been loaded and which ...
Posted By: adrian.boeh
Posted On: 10/22/2014 04:21 PM
Comments: 1
Category: Join
My input file, ".xlsx", has fields with numbers in monetary format, and with negative numbers that use parentheses. When I pull these in and try to use the Select tool to ...
Posted By: bethany.keeler
Posted On: 10/22/2014 08:38 AM
Comments: 1
Category: Preparation
The Input Tool reads Excel however many dashboards require multiple people to update a spreadsheet. Excel is too much of a hassle to share and update. Being able to read directly f ...
Posted By: tim.chandler
Posted On: 10/21/2014 03:34 AM
Comments: 1
Category: Connectors
Status: New
I want to use percentile for my data set, but it seems like doesn't work...
I'm doing RFM analysis and I need to rank the RFM into 5 category. That's why I need to perc ...
Posted By: k.koebisawa
Posted On: 10/20/2014 07:24 PM
Comments: 4
Category: Preparation
Hello,

I have multiple csv files that that are received weekly that I would like to first create an Alteryx database and then contiue to add as files are received.   The column la ...
Posted By: kpurcell
Posted On: 10/20/2014 08:20 AM
Comments: 2
Category: In Out
I know this is a reach, but it would be nice to have the ability to drag around points or lables on the map before outputing them.  Specific example, plotting competitor stores tha ...
Posted By: chris_cleckner
Posted On: 10/20/2014 08:20 AM
Comments: 0
Category: Reporting
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: 10/20/2014 07:26 AM
Comments: 0
Category: Data Investigation
Status: New
What is  content of the spline tool output object?  I would like to extract lists of variables and coefficiects, r_square, and fitted values for additional analyses and visualizing ...
Posted By: j_brzezinski
Posted On: 10/18/2014 10:07 AM
Comments: 0
Category: Predictive
Hello,
This error is returning on an Output Data object configured to save a dataset to an Access table.

There is another Output Data object configured to output to a different da ...
Posted By: sincerie.johnson
Posted On: 10/15/2014 01:25 PM
Comments: 2
Category: In Out
Test
Posted By: hillaryarcher
Posted On: 10/14/2014 09:25 AM
Comments: 0
Category: Installation
When will Beta Testing for the next version of Alteryx begin?  What are plans for indicating content and progress with the beta?
Posted By: j_brzezinski
Posted On: 10/14/2014 08:45 AM
Comments: 1
Category: User Groups
I'm having issues with the initial format of my data source. I'm a brand new user, mostly training myself, so please bear with me.

I'm pulling in long UPC numbers that ...
Posted By: bethany.keeler
Posted On: 10/14/2014 06:46 AM
Comments: 2
Category: In Out
Hi all,

I'm trying to implement a simple JOIN of two tables on a date range.

Here is the scenario:

 i) Transactions table got transactions for every day.
Date + Product + Qu ...
Posted By: sandeep.chayanam
Posted On: 10/14/2014 06:39 AM
Comments: 2
Category: Join
I've seen several Twitter macros and tools, among several other social media tools; however, I've never seen or heard of anyone hitting the LinkedIn API.  Is anyone familia ...
Posted By: landry.turner
Posted On: 10/14/2014 05:56 AM
Comments: 0
Category: Connectors
I have imported an excel table into Alteryx for further use in Tableau. I need to count the number of items (delimited by ;) in a cell. How can I do this?

Thank you!
Posted By: aurelie.toussaint
Posted On: 10/14/2014 05:29 AM
Comments: 2
Category: Common Use Cases
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: 10/14/2014 01:10 AM
Comments: 2
Category: Preparation
Status: New
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: 10/14/2014 12:56 AM
Comments: 0
Category: Preparation
Status: New
Can you fix Alteryx to time out instead of hang and go non-responsive when not connected to network drive.

Two scenarios:
1) I have a module that pulls from local files and a mapp ...
Posted By: sean.otto
Posted On: 10/11/2014 06:08 AM
Comments: 0
Category: In Out
Hi,

I have an multi-sheet excel file that I want to import data from one table (sheet) but I keep only data from xlnm#_FilterDatabase sheet which and don't know why.
I use Dyn ...
Posted By: mbsaad
Posted On: 10/10/2014 03:29 PM
Comments: 1
Category: In Out
Unless I'm missing the basics, I'm unable to scroll and pan during module runs.  I can zoom in and out, but not scroll or pan.
On large modules, I would love to be able to ...
Posted By: mike.hathaway
Posted On: 10/10/2014 12:03 PM
Comments: 2
Category: Common Use Cases
Status: New
Please include a function to support the conversion of data into this secure format.
Posted By: mark.frisch
Posted On: 10/10/2014 10:45 AM
Comments: 0
Category: Transform
Status: New
Hi,

How can I insert a variable in a file path to load automatically many field.

thank you
Posted By: mbsaad
Posted On: 10/10/2014 07:08 AM
Comments: 1
Category: In Out
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: 
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: 10/09/2014 11:55 AM
Comments: 0
Category: In/Out
Status: New
I need a macro that takes as input an integer representing the number of seconds the macro needs to wait until allowing the stream of data to continue.

My issue is that I have a f ...
Posted By: jhollingsworth
Posted On: 10/06/2014 11:23 AM
Comments: 2
Category: Macros
Add some sort of highlight to an input data icon that currently has a record limit set.  Maybe an orange exclamation point on top the icon visually queing the analyst that the sett ...
Posted By: keith.w.degregory.mil
Posted On: 10/06/2014 08:24 AM
Comments: 0
Category: In/Out
Status: New
2014 Shipping and Gallery Data Update Schedule
Posted On: 10/03/2014 03:02 PM
Category: 
Hi! Is there a reasonable way to export mutliple Alteryx outputs into the same excel file under different tabs? I found this explanation (http://community.alteryx.com/Data-Blending ...
Posted By: alexandra.mannerings
Posted On: 10/03/2014 09:17 AM
Comments: 3
Category: In Out
When I currently hit F1 when function is highlighted within properties window it brings me to tool help - it would be helpful if it brought you to help on the function.  Or if I ho ...
Posted By: keith.w.degregory.mil
Posted On: 10/03/2014 08:07 AM
Comments: 0
Category: Documentation
Status: New
Hi!!

How can I import 1 Excelfile with multiple sheets?
From every sheet I will import the range A7:W1000.

Thank a lot!

Cheers!

Gert-Jan
Posted By: g.neeft
Posted On: 10/03/2014 07:39 AM
Comments: 2
Category: Common Use Cases
Tool containers are great for organising complex modules and for disabling processes in modules. However they take up so much space on the canvas!

When trying to create a neat mod ...
Posted By: joe.lipski
Posted On: 10/03/2014 01:52 AM
Comments: 2
Category: Documentation
Status: New
When starting workflow from scratch I often build functionality in disjoint containers but would like away to indicate the order of running for containers (possibly by connecting w ...
Posted By: keith.w.degregory.mil
Posted On: 10/02/2014 12:22 PM
Comments: 0
Category: Connectors
Status: New
You changed how your load Calgary from 9.0 to 9.1.

My variable (column) names follow a nomenclature of x.aaaaa.bbbb which worked well for Calgary being able to parse by ".&qu ...
Posted By: sean.otto
Posted On: 10/01/2014 11:15 AM
Comments: 2
Category: Calgary
We have artisans that are collaborating on projects. They will need to share the resultes of their work within Alteryx.  In the Collection you can share applications but not result ...
Posted By: bruce.pierceall
Posted On: 09/30/2014 03:29 PM
Comments: 1
Category: User Groups
Can you put a check box on the container title bar to make it easier to enable/disable containers in the process window? And can you make the minimize/maximize option for a conatin ...
Posted By: keith.w.degregory.mil
Posted On: 09/26/2014 09:52 AM
Comments: 0
Category: Tips and Tricks
Status: Under Review
Comment boxes should not have to be 'configured' like other tools.  After dropping a box on the canvas the user should automatically be able to begin typing to complete the ...
Posted By: dketza
Posted On: 09/26/2014 09:51 AM
Comments: 0
Category: Documentation
Status: Planned
I have an app that contains 4 check boxes.  Each check box is independent, and when checked, two other prompts open up to the user (in this case, text boxes which are also independ ...
Posted By: mbarone
Posted On: 09/26/2014 09:51 AM
Comments: 0
Category: Analytic Appliances
Status: Under Review
I was wondering if anyone else in the community thought it would be a good idea for Alteryx to add the capability to import a Mapinfo raster file?  Currently you can work with MapI ...
Posted By: slinder
Posted On: 09/26/2014 09:50 AM
Comments: 2
Category: Spatial
Status: Under Review
Alteryx Designer should automatically save my modules on a regular basis so that if I have a failure of some sort, my hard work will not be lost.
Posted By: gjones
Posted On: 09/26/2014 09:48 AM
Comments: 2
Category: Troubleshooting
Status: Now Available
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: 
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 EngineSpatialAddress
I'd like a simple option to zoom to the full extent of my module, showing all the tools centered on the canvas.

Thank you.

An additional feature would be to have Alteryx be a ...
Posted By: michael.team
Posted On: 09/09/2014 11:06 AM
Comments: 0
Category: Common Use Cases
Status: New
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: 09/09/2014 10:56 AM
Comments: 0
Category: Analytic Appliances
Status: New
You can call me new school, but when I browse for inputs etc. in Alteryx, they are the old school windows interface where I have to hunt and peck through the file directory.  Can y ...
Posted By: sean.otto
Posted On: 08/28/2014 02:12 PM
Comments: 4
Category: Common Use Cases
Status: Under Review
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: 
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: InstallationGetting Started with AlteryxDataAlteryx EngineAddress
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: TroubleshootingIn OutAlteryx EngineDataInput Output
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: TransformAlteryx EngineInput OutputIn 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