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:

Hi,

I'm working on using an Alteryx workflow to publish reports to an internal Tableau server. Attempting to extract the Visual Analytics Kit for Tableau gives me errors with ...
Posted By: sonal.dighe
Posted On: 07/30/2015 12:32 PM
Comments: 0
Category: Troubleshooting
Hi ,

I am new to the Alteryx. Challenge for me analysing the Survey responce which resides in CSV files.

I have responces for all 22 questions.  my sample data for question 1 loo ...
Posted By: zuruprem
Posted On: 07/30/2015 10:42 AM
Comments: 1
Category: Common Use Cases
Hello

how can you output and file as a .txt doc

many thanks

denny
 
Posted By: denny.chan
Posted On: 07/30/2015 10:29 AM
Comments: 1
Category: In Out
Is there a tool or set of process in Alteryx to compare address data between two tables and merge the bad records with a clean one.
I am dealing with cleaning up of postal addresse ...
Posted By: vinod.zachariah
Posted On: 07/30/2015 09:00 AM
Comments: 2
Category: Data Investigation
Im trying to import multiple tabs from and xlsx file following the method discribed here: http://www.alteryx.com/blog/engine-works/reading-multiple-xls-tables The problem is that I ...
Posted By: paul.houghton
Posted On: 07/30/2015 08:01 AM
Comments: 2
Category: Troubleshooting
I am looking for help understanding how to apply email formatting using the Email tool (not the event). I have tried looking around, and I found this: http://www.alteryx.com/blog/e ...
Posted By: adrian.boeh
Posted On: 07/30/2015 07:53 AM
Comments: 0
Category: Reporting
I'm trying to connect to an Oracle database using the Input Tool.

When connecting via 32bit Oracle drivers, Alteryx throws this error.


When connecting via the 64-bit Oracle ...
Posted By: tlisti
Posted On: 07/30/2015 07:38 AM
Comments: 0
Category: Troubleshooting
I have few monthly tasks where the data is refereshed. My Input file is from the Oracle dba and the output file is on my local drive. I would like the output file to be overwritten ...
Posted By: ankush.nayyar
Posted On: 07/30/2015 02:30 AM
Comments: 3
Category: In Out
Hello

do you know how to open a Excel file ( as a data source) with a predefined Password?

many thanks

DC


 
Posted By: denny.chan
Posted On: 07/30/2015 02:28 AM
Comments: 0
Category: In Out
I have a filter which sometimes results in True condition and sometimes in False. I want to stop the False part from running when the conidition is true and vice versa. What I have ...
Posted By: pgandhi
Posted On: 07/29/2015 05:44 PM
Comments: 1
Category: Preparation
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: 07/29/2015 10:03 AM
Comments: 4
Category: Help Docs Tutorials
I have been successful in connecting to a List on our internal Share Point site, but when I run the extract from the List, it gives me everything except for the fields with the fie ...
Posted By: staufd1
Posted On: 07/29/2015 06:36 AM
Comments: 0
Category: Connectors
I use detours to bypass areas when I do not need them in the loop and it would be great if i just had a enable button (kind of like how you would control in a macro).  That way i d ...
Posted By: anthony
Posted On: 07/28/2015 01:18 PM
Comments: 0
Category: Developer
Status: New
We've been using PostgreSQL 9.3 with PostGIS to serve up data to QGIS and ArcGIS as well as provide multi-user editing for a variety of our data. It's been working wonderfu ...
Posted By: michael.team
Posted On: 07/28/2015 12:21 PM
Comments: 5
Category: In Out
At TargetSmart, we create a lot of CSV deliverables for our customers. Since Alteryx differentiates between blank strings and null values (a good thing), the CSV output is not cons ...
Posted By: ben.stroud
Posted On: 07/28/2015 08:13 AM
Comments: 1
Category: In/Out
Status: New
Is there a tool to dynamically create a new file directory on the hard drive (or network drive); whereby the file directory name would be a field in the incoming data, and the file ...
Posted By: patrick.mcauliffe
Posted On: 07/28/2015 07:56 AM
Comments: 0
Category: In Out
I have got a set of fields whose number is dynamic i.e sometimes data might return 5 fields and sometimes 10. Now, I need to create another field which is a concatenation of these ...
Posted By: pgandhi
Posted On: 07/28/2015 07:04 AM
Comments: 2
Category: Preparation
A minor question:
In the Filter tool, when filtering a numeric variable(say, Age) using the expression "21<=[Age]<=45", the tool does not filter to the intended age ...
Posted By: ywang
Posted On: 07/27/2015 07:35 PM
Comments: 1
Category: Preparation
Every time I add a tool container I default the Margin to "none." Could you make a default selection part of user settings? Thank you.
Posted By: gregory.w.hall
Posted On: 07/25/2015 09:48 AM
Comments: 0
Category: Developer
Status: New
A Gini index provides a measure of diversity for a particular continuous or catagorical variable.  It is usually used to measure concentration of wealth or income.  There are some ...
Posted By: j_brzezinski
Posted On: 07/24/2015 11:17 PM
Comments: 0
Category: Macros
One of our customers have a given us a bunch of files ( .ppa and .par files). They wanted us to do some analysis of the data contained in these files as they were not sure of what ...
Posted By: jaykumar
Posted On: 07/24/2015 01:08 PM
Comments: 0
Category: Macros
Sometimes I get conversion error messages or warnings that really don't matter, and it would be great if there was a function similar to spell check or grammer check where I co ...
Posted By: cbridges
Posted On: 07/22/2015 11:41 AM
Comments: 0
Category: Reporting
Status: New
I know you can add a field for "today" and then use that field to append the filename, so the output ends up as Ouput_Date.xlsx, but it would be great to be able to do th ...
Posted By: cbridges
Posted On: 07/22/2015 09:06 AM
Comments: 2
Category: In/Out
Status: New
Hi guys,

Do you know where I can download sample/template workflow for a certain industry? Say Banking and Finance industry?

Thanks!
Ean

PS: I tried looking in the Gallery but o ...
Posted By: sbhamid
Posted On: 07/21/2015 05:46 PM
Comments: 0
Category: Developer
Hi Guys,

Do you know where I can download sample/template workflows for a certain Industry for free? Say a Banking/Finance industry?

I tride the Gallery but only apps are availab ...
Posted By: sbhamid
Posted On: 07/21/2015 05:44 PM
Comments: 0
Category: Developer
2015 Shipping and Gallery Schedule
Posted On: 07/15/2015 09:53 AM
Category: SpatialDemographic Analysis
The capability to input/output R Datasets via the input/output tools, together with all the other data formats as well (like csv, Excel, SAS, SPSS, etc).
Posted By: santiago.restrepo
Posted On: 07/10/2015 02:10 PM
Comments: 2
Category: In/Out;Predictive
Status: Under Review
I would like to see the same functionalitly that the Output Tool has in the Render tool.  In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you ...
Posted By: don.searls
Posted On: 07/09/2015 07:30 AM
Comments: 1
Category: Reporting
Status: New
I have used the SharePoint List Connectors with our SharePoint 2010 (on prem) instance for some time now. It works great and has become invaluable. Unfortunately, I have been told ...
Posted By: castropn
Posted On: 07/08/2015 08:08 AM
Comments: 0
Category: Connectors
Status: New
Hi 

Wanted to control the order of execution of objects in Alteryx WF but right now we have ONLY block until done which is not right choice for so many cases 

Can we have a con ...
Posted By: s.pichaipillai
Posted On: 07/08/2015 03:52 AM
Comments: 3
Category: Developer
Status: New
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
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
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
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
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
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 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: 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 ProcessingData CleansingGetting StartedAlteryx EngineData documentation
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: Getting Started with AlteryxGeneralAlteryx 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: 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
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: