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:

If you create a macro that uses the Text Box interface tool and select the "Mask Text" to *** what's being inputed, if share a module that includes that macro  with s ...
Posted By: jimmy.romogo
Posted On: 11/21/2014 01:27 PM
Comments: 0
Category: Macros
I'm coming from Mapinfo, and I'm looking for a way to replicate the Proportional Sum function used to aggregate polygon data.  In MapInfo, I query the the polygons from a d ...
Posted By: matthew.callahan
Posted On: 11/21/2014 10:14 AM
Comments: 0
Category: Spatial
Hi ,

I want to Filter 'AbC'  From "SB-Fract AbC SERIES 1 RC DS"  in Field2  where Field2 has many rows. I want those value which has 'AbC' in there Field ...
Posted By: ashiques
Posted On: 11/21/2014 05:52 AM
Comments: 1
Category: Transform
Hi, I'm searching for a way to simply execute generic SQL commands against a server.  Specifically, I'd like to execute some stored procedures on the server after loading d ...
Posted By: dustin
Posted On: 11/20/2014 03:47 PM
Comments: 1
Category: Developer
I need to write a filter or formula or something that can search for 3 or 4 specific UPCs in a column. Each UPC has multiple rows of data. I've tried a few different configurat ...
Posted By: bethany.keeler
Posted On: 11/19/2014 05:58 AM
Comments: 3
Category: Preparation
Hi ,
Today i stuck in one position where my current module gaves an error because it doesnt found the Fields name. I define the field name in Formula tool for validation and harmon ...
Posted By: ashiques
Posted On: 11/18/2014 02:45 AM
Comments: 1
Category: Transform
Status: New
  Hi
When i used this Formula
IF left([Name], 7) == "A_Fract" THEN left([Name], 7) == "A_Fract" ELSE left([Name], 11) == "B_Analytics" ENDIF

I have ...
Posted By: ashiques
Posted On: 11/17/2014 03:21 PM
Comments: 1
Category: Preparation
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: 11/17/2014 11:00 AM
Comments: 2
Category: Preparation
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: 11/17/2014 07:04 AM
Comments: 3
Category: Connectors
Status: New
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: 11/17/2014 07:04 AM
Comments: 0
Category: Connectors
Status: New
Hi all,

I have a table in whcih i have many column's but i want to make a new column in "Fract" which is sum of all "A_Fract" Column's.
Currently there ...
Posted By: ashiques
Posted On: 11/17/2014 05:40 AM
Comments: 3
Category: Developer
We've had several requests from clients for the ability to import password protected Excel spreadsheets into Alteryx.  Within Alteryx, it would be good to specify the password ...
Posted By: cbradbrook
Posted On: 11/13/2014 09:45 AM
Comments: 0
Category: In/Out
Status: New
I would like to set up a connection to a secure FTP site allowing me to schedule upload and download of files.  I am assuming I would need to create a text input file and configure ...
Posted By: jschroeder
Posted On: 11/12/2014 04:59 PM
Comments: 1
Category: Connectors
Hi All,

I have a field which i transpose and get this value in  Row = "04/04/09". Now i have to update the new  file in previous file which have different field name whi ...
Posted By: ashiques
Posted On: 11/12/2014 04:42 PM
Comments: 1
Category: Transform
Hi ,

My question is that i have two files. One is my old file and second was new file. In my new file The header are as this format:- 4 WEEKS ENDING 07/31/104 WEEKS ENDING 08/28/1 ...
Posted By: ashiques
Posted On: 11/12/2014 04:39 PM
Comments: 1
Category: Transform
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: 11/10/2014 02:45 PM
Comments: 0
Category: Predictive
Status: New
This really isnt a question, but more of a tool update suggestion.

Even though the tool has an option to specify a comparison date, the verbiage on the report output remains " ...
Posted By: jimmy.romogo
Posted On: 11/10/2014 01:19 PM
Comments: 0
Category: Predictive
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: 11/10/2014 11:35 AM
Comments: 0
Category: Troubleshooting
In Input we have 9 Column by which we have to make out put. So the formula for making new column is sum of last three column's divide by 3. But the main concern is that my inpu ...
Posted By: ashiques
Posted On: 11/10/2014 06:11 AM
Comments: 3
Category: Common Use Cases
Hi,

Instead of having multiple filters to create mutliples new branches for downstream analysis, Alteryx should have one filter with multiples ouputs ports. Each filter would is o ...
Posted By: alteryx
Posted On: 11/09/2014 03:44 PM
Comments: 0
Category: Preparation
Status: New
Possibility to deselect fields directly in the input (shape, csv, tab, etc).

 
Posted By: alteryx
Posted On: 11/09/2014 03:41 PM
Comments: 0
Category: In/Out
Status: New
When using an App from the gallery, I would like to keep track of how many (Allocate dataset) checkboxes a user has toggled real-time by having a counter on the same form. Function ...
Posted By: sphwillis
Posted On: 11/07/2014 11:57 AM
Comments: 0
Category: Developer
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: 11/05/2014 03:27 PM
Comments: 1
Category: Predictive
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: Getting Started
 Output Data (44) Error opening connect string: Microsoft Access Database Engine: Cannot update. Database or object is read-only.\3027 = -118490897

I read the previous post on thi ...
Posted By: travis.jones01
Posted On: 11/04/2014 10:17 AM
Comments: 1
Category: In Out
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: 11/03/2014 11:56 AM
Comments: 1
Category: Troubleshooting
Status: New
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: Licenses and ActivationInstallationQuick Start GuidesTips and Tricks
I have decompiled the AlteryxHelp.chm file, re-generated the help project, index and contents files and added my own compiled HTML help as a merge file in the AlteryxHelp.hhp proje ...
Posted By: tcarroll
Posted On: 10/31/2014 09:00 AM
Comments: 1
Category: Troubleshooting
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/31/2014 08:42 AM
Comments: 3
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/29/2014 10:40 AM
Comments: 2
Category: Connectors
I cannot copy any text and paste it into the Expression window of the Formula Tool.  I am probably doing something simple and stupid but I cannot figure it out.  Can anyone help?

...
Posted By: slinder
Posted On: 10/29/2014 10:31 AM
Comments: 2
Category: Preparation
I have been using the outputs from Spline Regression to facillitate analysis of demographic data (specifically Department of Labor Quarterly Employment data).  I have data from 199 ...
Posted By: j_brzezinski
Posted On: 10/28/2014 01:28 PM
Comments: 0
Category: Demographic Analysis
Status: New
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: 
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 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
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: 1
Category: Preparation
Status: New
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: 3
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
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
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: 
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
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: Getting Started with AlteryxGeneralQuick 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
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 AlteryxAddressAlteryx EngineData
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: TroubleshootingInput OutputDataAlteryx EngineIn Out
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: Input OutputAlteryx EngineTransformIn 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: Alteryx EngineGetting Started with AlteryxTips and Tricks