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:

How do you get rid of special characters like ™ and ® when you are preparing data from Excel for MySQL. I tried using a character replace but it doesn't seem to pick them up. A ...
Posted By: andrew
Posted On: 05/25/2015 07:10 AM
Comments: 1
Category: Preparation
I would be great to have a json-stat parser. There are probably ways of doing it with the JSON parser but it is appears to be a little bit tricky.
Also, it would be nice to be able ...
Posted By: leif.engdell
Posted On: 05/25/2015 04:16 AM
Comments: 0
Category: Parse
Status: New
We have several .txt input files (same structure) that need to be combined into one file.  But all the files have summary information on the first 6 rows.  Alteryx help me created ...
Posted By: gilbert.2.carmichael
Posted On: 05/23/2015 05:12 AM
Comments: 0
Category: In/Out
Status: New
We would like to have the ability to overwrite sheets in macro-enabled Excel workbooks.  Several of our scorecarding templates leverage macros for Excel events, protection, and int ...
Posted By: michael.carrico
Posted On: 05/22/2015 01:07 PM
Comments: 1
Category: In/Out
Status: Planned
I am having trouble setting up a Basic Filter where I would like to filter out 3 numbers from a field. I would only like to look at records that have those three numbers in a field ...
Posted By: michael
Posted On: 05/22/2015 12:18 PM
Comments: 0
Category: Preparation
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: 05/21/2015 04:14 PM
Comments: 2
Category: Parse
Status: Under Review
When developing a module, I generally BROWSE the final data until I'm ultimately ready to generate output.  Then I need to add or replace a browse tool with an output tool.  Pe ...
Posted By: mark.frisch
Posted On: 05/21/2015 12:44 PM
Comments: 0
Category: In/Out
Status: Coming Soon
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: 05/21/2015 08:38 AM
Comments: 3
Category: Troubleshooting
I have been unable to find a way to output the the rules generated by a decsion tree.  Can someone explain how I might be able to do this?
Thanks!
Posted By: virginia.long
Posted On: 05/21/2015 04:54 AM
Comments: 1
Category: Predictive
When I setup an In-DB connection I need a way to select only the tables I want to see. Basically a way to favorite the most frequenently used tables and also the ability to add a d ...
Posted By: jjones2
Posted On: 05/20/2015 04:22 PM
Comments: 1
Category: In/Out
Status: New
How to derive a categorical field to a collection of flag (true/false) fields in Alteryx?
E.g.: field_male_female => flag_male and flag_female
I understand: I can do it with R n ...
Posted By: molnarm
Posted On: 05/20/2015 05:56 AM
Comments: 2
Category: Common Use Cases
Apologizes if this is a simple solution but I need to remove a charcter from the data in the column to be able to convert form sting to a double format.  Would RegEx assist with th ...
Posted By: kpurcell
Posted On: 05/20/2015 12:49 AM
Comments: 3
Category: Partners
Hi, I am fairly new to alteryx and need some guidence for setup my joins and unions in terms of best practice/order.

I keep running into the same issues over and over in projects ...
Posted By: anthony
Posted On: 05/19/2015 04:50 PM
Comments: 0
Category: Join
If I have a business address and want to collect all zip codes within a 5 mile radius...how would you do it?
Posted By: david_rogers
Posted On: 05/19/2015 12:50 PM
Comments: 1
Category: Address
I am trying to parse out Twitter handles from numerous fields. The column header is titled "Twitter Body" and this wil capture the text of someones tweet. As you can imag ...
Posted By: michael
Posted On: 05/19/2015 12:50 PM
Comments: 2
Category: Parse
209 Where Ever Dr Orchard Park NY 14127 2222  (...all one string)
1002 N Whatever Suite 400 Browns Crossroads KY 40602 1111 (...all one string)

I have a process that pulls the zip ...
Posted By: david_rogers
Posted On: 05/13/2015 08:20 PM
Comments: 3
Category: Tips and Tricks
It would be very helpful if Alteryx allowed us to manually configure the IP and port number of a web proxy in instances when we are accessing online services. 
Posted By: mike.psaris
Posted On: 05/12/2015 01:26 PM
Comments: 0
Category: Connectors
Status: New
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: 05/12/2015 09:26 AM
Comments: 1
Category: In/Out
Status: Planned
Hi, ive been using the tweeter tool to pull data in my workflow based on hashtags.  It works great!, but when I try to filter just on a twitter handle I get very mixed results.   D ...
Posted By: orlandop
Posted On: 05/11/2015 01:13 PM
Comments: 0
Category: Developer
I created a web app with some questions and a couple of "Link" objects.  Both links are very small CSV template and an MS Excel "how to" instructions document.  ...
Posted By: matt.stoffa
Posted On: 05/08/2015 10:00 AM
Comments: 0
Category: Analytic Applications
Hi,
I'm trying to get some data from Salesforce using the new Salesforce Reporting REST API. I managed to get it to work with the download connector, but the API returns a max ...
Posted By: pablo.luna
Posted On: 05/08/2015 08:08 AM
Comments: 2
Category: Macros
Is there any way to pass variables to run command object? I want to be able to dynamically pull data and feed it into my executable using arguments rather then coding my executable ...
Posted By: mmoss
Posted On: 05/03/2015 05:35 PM
Comments: 1
Category: Developer
Hi,

I was hoping if some one could tell me an easier way campared to Batch Macros for inputting multiple files using directory and dynamic input tools? And if you could tell me if ...
Posted By: pratik_jangale
Posted On: 05/03/2015 05:21 PM
Comments: 1
Category: In Out
I am trying to fetch Latitudes and Longitudes using Address, city, State and Zip using Alteryx Geocoding App but it takes only 1000 records at a time. Is there any other alternativ ...
Posted By: divya.gulati
Posted On: 05/01/2015 12:40 AM
Comments: 2
Category: Spatial
Hello,

I was hoping if someone could help if there is an easier way to do this.

I have a table with userid, activity code and activity date stamp.  Is there a formula that would ...
Posted By: kpurcell
Posted On: 04/30/2015 06:26 AM
Comments: 2
Category: Preparation
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: 04/29/2015 11:42 AM
Comments: 1
Category: Join
Status: Now Available
It's all in the title...
Posted By: dmagnus
Posted On: 04/28/2015 10:24 AM
Comments: 0
Category: Connectors
Status: New
Hi

Does anybody know how to deal with a file like this?

Tableau seems to open it fine but I can't work out how to open this in Alteryx. Delimiters are inconsistent as " ...
Posted By: debra.howard
Posted On: 04/28/2015 06:01 AM
Comments: 4
Category: In Out
I'm successfully using the date format (DateTimeFormat([TRAN_DT],"%d-%b-%Y")) to get dd-Mon-yyyy (i.e. 24-Apr-2015) how do I get it to produce dd-MON-yyyy (i.e. 24-AP ...
Posted By: jim.s.brady
Posted On: 04/27/2015 06:40 AM
Comments: 1
Category: Preparation
Hi

Does anybody know how to deal with a file like this?

Tableau seems to open it fine but I can't work out how to open this in Alteryx. Delimiters are inconsistent as " ...
Posted By: debra.howard
Posted On: 04/27/2015 06:10 AM
Comments: 0
Category: In Out
Webinar Training Module: Tips and Tricks (Dec 13)
Attached is the module created during the Tips and Tricks public webinar recorded December 2013.
Posted On: 04/27/2015 04:05 AM
Category: Data documentation
Alteryx Certified Module Requirements
Posted On: 04/27/2015 04:05 AM
Category: Alteryx serverGetting Started
Using the Tool Container
This will overview the Tool Container tool and its functions.
Posted On: 04/27/2015 04:05 AM
Category: All
Southern California Alteryx User Group meeting on Tuesday October 29, 2013 2-4:30pm
Join us for our next Southern California Alteryx User Group meeting on Tuesday, October 29, 2013 from 2-4:30 pm PST
Posted On: 04/27/2015 04:05 AM
Category: Professional services
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: 04/27/2015 04:05 AM
Category: Getting Started with AlteryxAlteryx EngineData documentation
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: 04/27/2015 04:05 AM
Category: Alteryx EngineAll
Batch Macros: An Example
We often come across a situation that calls for a macro. Many users are unfamiliar with why they would use a different type of macro, so Ned, our CTO has written a blog post about ...
Posted On: 04/27/2015 04:05 AM
Category: Analytic Apps macrosAlteryx EngineAll
How To: Use Alteryx To Connect To Google Analytics
By now you are probably aware that Alteryx has the ability to connect to many different cloud services. This article touches on a series of two YouTube video tutorials explaining ...
Posted On: 04/27/2015 04:05 AM
Category: 
Alteryx Partner Technical Training Guide- Module 1 Managing Data
Alteryx Partner Technical Training Guide Module 1 - Managing Data 1(a)- Parsing 1(b)-Basic Data Blending
Posted On: 04/27/2015 04:05 AM
Category: Getting StartedData ProcessingData CleansingAlteryx EngineData documentation
Currently we are limited to chossing one of two layout direction options, vertical or horizontal.  Why not make the direction assignable at the tool icon instead of as a module lev ...
Posted By: fharper
Posted On: 04/24/2015 11:36 AM
Comments: 0
Category: Connectors
Status: New
When scoring data if you have values in predictor fields not seen in the data that was used to build the model the score tool will not score the record.  Makes sense but it would b ...
Posted By: fharper
Posted On: 04/24/2015 11:23 AM
Comments: 0
Category: Predictive
Status: New
Could there be an option or checkbox added, possibly in the canvas menu or something like that, where I could tell Designer to RETAIN all browses when creating a debug module?

Cur ...
Posted By: erik
Posted On: 04/22/2015 08:33 AM
Comments: 4
Category: Data Investigation
Status: Coming Soon
While trying to debug data parsing, I end up with browse tools all over the place and it makes the pallet a mess and time consuming to organize.

It would be much nicer to just hav ...
Posted By: anthony
Posted On: 04/22/2015 08:29 AM
Comments: 1
Category: Data Investigation
Status: Coming Soon
One of those small little annoyances that can add some extra time to development is how when you browse for a file (either with the Input Tool or Output Tool) it always defaults to ...
Posted By: jbednarz
Posted On: 04/22/2015 07:53 AM
Comments: 1
Category: In/Out
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: 04/21/2015 10:24 AM
Category: GeneralGetting Started with AlteryxAlteryx server
I haven’t found a common spatial file format to use between Alteryx, MapInfo Pro and ArcMap.  The one file/db type that all 3 software packages have the ability to use is SQLite.  ...
Posted By: kenneth.s.buck
Posted On: 04/21/2015 08:03 AM
Comments: 0
Category: Spatial
Status: New
We have a number of clients now using Exasol databases and they would like to connect Alteryx to this data source.  There is currently some difficulty connecting using Alteryx and ...
Posted By: cbradbrook
Posted On: 04/17/2015 11:54 AM
Comments: 4
Category: Connectors
Status: New
I have several regular outputs I use that are in both Excel and PDF (depending on who I am sending them to).

The format of these is always:

For Excel, create a summary sheet and ...
Posted By: patrick.mcauliffe
Posted On: 04/17/2015 07:55 AM
Comments: 0
Category: Reporting
Status: New
Posting on behalf of Door To Door Organics:

Canvases can get pretty huge and it's an unintuitive pain to have to scroll and shift+scroll across a large canvas, and an even big ...
Posted By: cmartin
Posted On: 04/07/2015 01:58 PM
Comments: 2
Category: Common Use Cases
Status: New
As a system admin, I need a simple, reliable way to back up the Alteryx Server without shutting it down first. A hot-backup (and restore) utility that includes a consistent copy of ...
Posted By: andrew_macey
Posted On: 04/03/2015 04:49 PM
Comments: 0
Category: Installation
Status: New
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: 
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
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: Data documentationLegal Templates
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 macrosGetting Started with AlteryxAlteryx EngineData documentation
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: