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 would I convert a string of numbers 3037777777 into a classic phone number format: 303-777-7777. I know you can accomplish this in excel through the following function =REPLACE ...
Posted By: benjamin.hoppin
Posted On: 07/06/2015 01:45 PM
Comments: 3
Category: Preparation
I would like to create one additonal row of the same data if a certain string is in two fields of my data in one row. How do I acccomplish this?

For example, if the one of the fie ...
Posted By: benjamin.hoppin
Posted On: 07/06/2015 10:08 AM
Comments: 0
Category: Preparation
Very nice to be able to extend Alteryx with R programs or CMD execution.  Please, please, please add a connection to Python!
Posted By: anthony.brown
Posted On: 07/06/2015 07:12 AM
Comments: 0
Category: Connectors
Status: New
Configurable hotkeys/keyboard shortcuts would be awesome.  For instance, select/deselect highlighted fields or remove prefix are two commands that I use frequenctly but which are b ...
Posted By: anthony.brown
Posted On: 07/06/2015 07:06 AM
Comments: 0
Category: Common Use Cases
Status: New
I know this has been suggested before, but it would be great if calculations and transformations could be cached between workflow executions.  Perhaps the browse tools could be con ...
Posted By: anthony.brown
Posted On: 07/06/2015 07:01 AM
Comments: 0
Category: Common Use Cases
Status: New
Hi,

I am using an ODBC Connection to connect with Redshift to load the data from Salesforce via Salesforce connector. While running the module it fails to create the table and giv ...
Posted By: rahuls
Posted On: 07/06/2015 05:10 AM
Comments: 5
Category: Troubleshooting
Has anyone experienced any problems with the R tool when they have multiple R tools in the same workflow. 
I have a workflow that contains three R tools, each of the tools are usin ...
Posted By: mutuelinvestor
Posted On: 07/05/2015 06:01 AM
Comments: 0
Category: Developer
Has anyone experienced any problems with the R tool when they have multiple R tools in the same workflow. 
I have a workflow that contains three R tools, each of the tools are usin ...
Posted By: mutuelinvestor
Posted On: 07/05/2015 06:01 AM
Comments: 0
Category: Developer
default file path in "File Browser" interface app would be a nice to have feature. Similar to what we have in Numeric, Text etc. interface app.
Posted By: shailesh_patel
Posted On: 07/02/2015 12:45 PM
Comments: 1
Category: Tips and Tricks
Status: Under Review


Within the mapping tool, please add an alignment option (left/center/right) within the label options (when wrapping).
Posted By: alteryx
Posted On: 07/02/2015 12:44 PM
Comments: 1
Category: Reporting;Spatial
Status: Under Review
Would be great if we could right click on an input and in addition to having "convert to macro input" there was an option for "convert to dynamic input".
Posted By: patrick.mcauliffe
Posted On: 07/02/2015 12:43 PM
Comments: 2
Category: In/Out
Status: Under Review
Allow the User to 'de-authenticate' a license so it can be installed on a new laptop.
Posted By: mark.g.desroches
Posted On: 07/02/2015 09:38 AM
Comments: 2
Category: Installation
Status: Now Available
It might be helpful to be able to use an API to call and pass parameters to/from an Alteryx App or Workflow on an Alteryx Server.  Then a user could use a  browser or another appli ...
Posted By: gilbert.2.carmichael
Posted On: 07/02/2015 09:33 AM
Comments: 3
Category: In/Out
Status: Now Available
Hello,
I need to build out the work flow with 12 tables. Now sure the best way to start. We are using the product specifically for this task..

I have included how I built it in Ta ...
Posted By: michael.franz
Posted On: 07/02/2015 08:52 AM
Comments: 2
Category: Join


Hi,

I am new to Alteryx but have been looking at the Designer with Spatial for the last 4 weeks.  It is great but think that there are some dubious results. As you can see I hav ...
Posted By: peter.vousden
Posted On: 07/01/2015 02:10 AM
Comments: 0
Category: Spatial
My goal is to establish a line of convenience between two points.  This is VERY SIMILAR to non-overlapping trade areas, but with a twist.  We need to visually inspect areas that ar ...
Posted By: matt.stoffa
Posted On: 06/30/2015 03:01 PM
Comments: 0
Category: Spatial
How can I capture the log file location that is created during the module run?  I'd like to use data from the log file in a post run event, but how can I locate the associated ...
Posted By: ben.degiulio
Posted On: 06/30/2015 06:20 AM
Comments: 2
Category: Tips and Tricks
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: 06/29/2015 02:07 PM
Comments: 5
Category: Help Docs Tutorials
Hello,

I am running a decision tree and when I am running it on a large number of variables, the tree image gets squished. Any idea if we can somehow customize this image? 
Posted By: sakenk
Posted On: 06/29/2015 07:25 AM
Comments: 0
Category: Predictive
Posted By: jjones2
Posted On: 06/29/2015 06:10 AM
Comments: 3
Category: Troubleshooting
Hi everyone,
I was wondering if any of you tried to dynamically configure the URL, credentials, list name properties of sharepoint list input/output tools and get it working succes ...
Posted By: sandeep.chayanam
Posted On: 06/29/2015 05:26 AM
Comments: 0
Category: Connectors
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: 06/26/2015 02:48 PM
Category: Alteryx server
Is MSA code really available in the CASS tool? It is listed in the output parameter options, but when we check it, the output has nothing in that field - a few are showing (null), ...
Posted By: sandy.pettinger
Posted On: 06/26/2015 09:37 AM
Comments: 0
Category: Address
I have an address string with the zip code in variable positions in the string.  it's not always at the end.  I've been able to parse the string but the zip code falls into ...
Posted By: jerome.schlafer
Posted On: 06/26/2015 09:07 AM
Comments: 2
Category: Parse
I would like to know if there was a way to re create a Pivot table in tabular form like in Excel in Alteryx.
For example, I have some fields that are the same but 2 strings for the ...
Posted By: xgarciadeparedes
Posted On: 06/25/2015 09:02 PM
Comments: 4
Category: Reporting
Greenplum / Postgresql Bulk Loader Capability much like the oracle and MS Sql.

Thanks!
John
Posted By: john.colgan
Posted On: 06/25/2015 03:13 PM
Comments: 1
Category: In/Out
Status: New
Hi everyone,
I was wondering if any of you tried to dynamically configure the URL, credentials, list name properties of sharepoint list input/output tools and get it working succes ...
Posted By: sandeep.chayanam
Posted On: 06/25/2015 03:14 AM
Comments: 0
Category: In Out
Hello All,

I am new to Alteryx.. I wanted know there any plugin/Kit do I need to install to publish the .tde to tableau server. I ahve checked in 9.5 designer and I was unable to ...
Posted By: venkatamuni.madduru
Posted On: 06/25/2015 12:42 AM
Comments: 1
Category: Developer
I'd like to publish an app that allows to user to choose the location where the data should be output.  Anyone have any ideas how that might work?

Thanks!
Posted By: brad.j.crep
Posted On: 06/24/2015 11:25 AM
Comments: 0
Category: Analytic Applications
Howdy,

I've been creating a predictive model. Before diving deep into the modelling task, I began by trying out the main predictive tools available.

Please find here a very s ...
Posted By: romano.felipe
Posted On: 06/24/2015 07:03 AM
Comments: 0
Category: Predictive
What Does The Connection Info Actually Mean?
Have you ever wondered what the file size in the connection between two tools actually means? Click through to find out!
Posted On: 06/23/2015 03:15 PM
Category: 
Would be great if i could just select x number of tools and just say add to a new container vs creating container and then dragging into said container.
Posted By: anthony
Posted On: 06/19/2015 08:02 AM
Comments: 1
Category: Documentation
Status: New
On the “Multi-Field Formula” tool, the default is to “copy output fields and Add….”  I think the default should NOT copy. I’m using this tool to trim all of the blank spaces, and c ...
Posted By: terri_hancock
Posted On: 06/18/2015 06:39 AM
Comments: 1
Category: Preparation
Status: Under Review
Hello,

It would be great if there was an option to compute 'median' on numerical data column in 'cross-tab' tool. We trust 'median' a lot more than 'av ...
Posted By: aliona.manvae
Posted On: 06/18/2015 06:32 AM
Comments: 1
Category: Data Investigation
Status: Under Review
When using ./*.csv for an input (relative path and wildcard), a preview does not show in the Properties area of the input tool.  Can this be added?

Posted By: dan.loman
Posted On: 06/17/2015 02:58 PM
Comments: 0
Category: Preparation
Status: New
It would be great if Alteryx developed an option to keep data transformations and additions already ran through the module. After adding new tools to the module, then the module wo ...
Posted By: bschmidt
Posted On: 06/17/2015 02:16 PM
Comments: 1
Category: Common Use Cases;Tips and Tricks
Status: Under Review
Sometimes when you make changes to a filter tool or some other tool's configuration and immediately click on another tool on your workflow, the chanegs you made to your first t ...
Posted By: chris_cleckner
Posted On: 06/17/2015 02:13 PM
Comments: 1
Category: Developer
Status: Under Review
I haven't seen this idea posted exactly this way...

Right now the browse results are only available while a workflow is open. It would be great if they could be saved until th ...
Posted By: cbridges
Posted On: 06/17/2015 02:09 PM
Comments: 4
Category: Preparation
Status: Under Review
It would be great to just have a little tool like a comment box that could be based on whatever you want... like if you always want to see the max date at a certain point, or the g ...
Posted By: cbridges
Posted On: 06/17/2015 02:02 PM
Comments: 2
Category: Preparation
Status: Under Review
Goal: My goals is to pull Marketo Lead Data via the Marketo Input SOAP API Connector and have specificied only 3 columns to pull for 1 day. 

Issue: It appears that the Marketo Inp ...
Posted By: eric.ramos
Posted On: 06/12/2015 01:32 PM
Comments: 1
Category: Connectors
Status: New
Just wondering if, like the Trade Area Tool, you can develop an option to use a field-defined value for percentage or count of records moving through the sample tool.

Thanks.
Posted By: jalbertini
Posted On: 06/09/2015 12:16 PM
Comments: 1
Category: Preparation
Status: New
Hi Alteryx Team,

My work is to create Output from Alteryx and upload the Output file into Tibco Spotfire. So i want a system in which Alteryx output directly goes in to the Tibco ...
Posted By: ashiques
Posted On: 06/09/2015 12:50 AM
Comments: 1
Category: In/Out
Status: New
Inspire 2015: Tips & Tricks
Inspire 2015 Tips & Tricks PDF document
Posted On: 06/02/2015 07:26 AM
Category: 
In-Database Processing FAQ
Click through for an in-depth FAQ around the new In-Database tools!
Posted On: 05/27/2015 02:24 PM
Category: 
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: Getting StartedAlteryx server
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 AlteryxData documentationAlteryx Engine
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: Alteryx EngineAnalytic Apps macrosAll
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: Data CleansingData documentationAlteryx EngineGetting StartedData Processing
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
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: AllAnalytics Gallery
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
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: