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:

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: 01/30/2015 08:43 AM
Comments: 0
Category: Alteryx designer
Hi,

I have a PC with a French setting. So the decimal separator is comma and not dot.

I have a issue when I'm tying to convert string data into double data using the "se ...
Posted By: thierry.chauvier
Posted On: 01/30/2015 05:45 AM
Comments: 0
Category: Alteryx designer
Hi,

I am trying to pull out some data from LeadHistory object from Salesforce using the Alteryx Salesforce connector. However, it does not list the 'LeadHistory' object na ...
Posted By: rahuls
Posted On: 01/29/2015 09:53 PM
Comments: 0
Category: Alteryx University
Have a feature in Alteryx that automatically and dynamically creates documentation or a SOP standard operating procedure. I imagine the flow and connectivity of each process  would ...
Posted By: cameronclark
Posted On: 01/29/2015 06:18 PM
Comments: 0
Category: Documentation
Status: New
Have a feature in Alteryx that automatically and dynamically creates documentation or a SOP standard operating procedure. I imagine the flow and connectivity of each process  would ...
Posted By: cameronclark
Posted On: 01/29/2015 06:18 PM
Comments: 0
Category: Documentation
Status: New
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: 01/29/2015 08:47 AM
Comments: 0
Category: In/Out
Status: New
I'm a beginner with Alteryx.
Can someone please help explain how can I use Multi-Row Formula to create running totals.
Also, how can Multi-Row Formula be used to replicate SUMI ...
Posted By: savannahyu
Posted On: 01/28/2015 11:36 AM
Comments: 1
Category: Partners
Hi all,

I'm trying to connect to an offsite sql database and Alteryx is throwing the error: "Connection Error: Login failed for user 'username'".

I use the ...
Posted By: jstauss
Posted On: 01/28/2015 11:26 AM
Comments: 0
Category: Pricing
It would be handy to have an increment function similar to SQL's Identity datatype that allows you to specify a seed and increment value.  It would seem like a really simple to ...
Posted By: danielkresina
Posted On: 01/28/2015 08:01 AM
Comments: 4
Category: Preparation
Status: New
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: 
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: Pricing
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: Getting Started with AlteryxGeneralAlteryx server
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: Industry News
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 macrosGetting Started with AlteryxData documentationAlteryx Engine
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: Help Docs Tutorials
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: All
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: Help Docs Tutorials
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: All
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: Industry News
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: Personas
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: Competitors
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: Alteryx analytics gallery
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: All
test
Posted By: nick
Posted On: 01/08/2015 02:05 PM
Comments: 1
Category: All
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: All
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: Data documentation
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
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: Personas
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 analytics galleryAlteryx Engine
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
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: Alteryx designerAlteryx analytics galleryAlteryx serverData documentation
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 EngineAll
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: All
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: All
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 EngineData documentation
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 EngineAll
Rating: