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!!

How can I import 1 Excelfile with multiple sheets?
From every sheet I will import the range A7:W1000.

Thank a lot!

Cheers!

Gert-Jan
Posted By: g.neeft
Posted On: 10/01/2014 01:38 PM
Comments: 1
Category: Common Use Cases
You changed how your load Calgary from 9.0 to 9.1.

My variable (column) names follow a nomenclature of x.aaaaa.bbbb which worked well for Calgary being able to parse by ".&qu ...
Posted By: sean.otto
Posted On: 10/01/2014 11:15 AM
Comments: 2
Category: Calgary
We have artisans that are collaborating on projects. They will need to share the resultes of their work within Alteryx.  In the Collection you can share applications but not result ...
Posted By: bruce.pierceall
Posted On: 09/30/2014 03:29 PM
Comments: 1
Category: User Groups
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: 09/29/2014 10:53 AM
Comments: 2
Category: In Out
HI All,

I am trying to configure a filter from a set of choices chosen from a list box in an analytical app.  I cannot figure out how to get the output from the list box to confor ...
Posted By: slinder
Posted On: 09/26/2014 03:47 PM
Comments: 4
Category: Preparation
Can you put a check box on the container title bar to make it easier to enable/disable containers in the process window? And can you make the minimize/maximize option for a conatin ...
Posted By: keith.w.degregory.mil
Posted On: 09/26/2014 09:52 AM
Comments: 0
Category: Tips and Tricks
Status: Under Review
Comment boxes should not have to be 'configured' like other tools.  After dropping a box on the canvas the user should automatically be able to begin typing to complete the ...
Posted By: dketza
Posted On: 09/26/2014 09:51 AM
Comments: 0
Category: Documentation
Status: Planned
I have an app that contains 4 check boxes.  Each check box is independent, and when checked, two other prompts open up to the user (in this case, text boxes which are also independ ...
Posted By: mbarone
Posted On: 09/26/2014 09:51 AM
Comments: 0
Category: Analytic Appliances
Status: Under Review
I was wondering if anyone else in the community thought it would be a good idea for Alteryx to add the capability to import a Mapinfo raster file?  Currently you can work with MapI ...
Posted By: slinder
Posted On: 09/26/2014 09:50 AM
Comments: 0
Category: Spatial
Status: Under Review
Alteryx Designer should automatically save my modules on a regular basis so that if I have a failure of some sort, my hard work will not be lost.
Posted By: gjones
Posted On: 09/26/2014 09:48 AM
Comments: 2
Category: Troubleshooting
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: 09/24/2014 02:48 PM
Category: Quick Start GuidesGetting Started with AlteryxGeneral
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: 
Is there any way to compress data in LAteryx?  I am working with large data sets and really need to compress the data for output.
Posted By: kmcdowell
Posted On: 09/23/2014 04:11 PM
Comments: 2
Category: In Out
Hi all,

I have a error in .xlsx.
Error: Output (246): Internal Error in DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: Multiple-step OLE DB operation generated error ...
Posted By: ashiques
Posted On: 09/22/2014 08:53 AM
Comments: 2
Category: In Out
The Alteryx documentation indicates that AlteryxEngineCmd.exe should return one of the following:
0 - Success 1 - Warnings Exist 2 - Errors Exist However, I've recently ...
Posted By: ben.stroud
Posted On: 09/17/2014 02:04 PM
Comments: 3
Category: Developer
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: 
When saving non-spatial data to a MapInfo table and selecting [None] for the Spatial Object Field, it still produces a .map file with no objects.

Ken
Posted By: kenneth.s.buck
Posted On: 09/17/2014 06:21 AM
Comments: 4
Category: In Out
I'm trying to take a polygon radius and break it into its 8 components parts based on cardinal direction so that I ended up with 8 polygons.  So far, I've taken my polygon, ...
Posted By: todd.henry
Posted On: 09/12/2014 02:58 PM
Comments: 1
Category: Spatial
Hello fellow artisans,

I have two columns in csv format. Both are strings. I would like to measure the similarity using the fuzzylogic node in Alteryx. I only need two compare the ...
Posted By: paolo.carbone
Posted On: 09/12/2014 02:21 PM
Comments: 1
Category: Data Investigation
Hi

I am using Alteryx designer version for doing survival analysis. I could not find a node available for the same in Alteryx so wrote a quick R code. What I need to figure out is ...
Posted By: nikhlesh.daga
Posted On: 09/10/2014 03:37 PM
Comments: 1
Category: Analytic Applications
  How can I create variable in  Alteryx because I want to read a file  and I want to save the first part of the name in a variable to read many filed wich ...
Posted By: mbsaad
Posted On: 09/10/2014 02:42 PM
Comments: 1
Category: In Out

I wanted to read multiple Excel files at once wich have a part of the name in common where I can put (*), but the sheets have the same name as the file.

Help
Posted By: mbsaad
Posted On: 09/10/2014 02:34 PM
Comments: 1
Category: In Out
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
I'd like a simple option to zoom to the full extent of my module, showing all the tools centered on the canvas.

Thank you.

An additional feature would be to have Alteryx be a ...
Posted By: michael.team
Posted On: 09/09/2014 11:06 AM
Comments: 0
Category: Common Use Cases
Status: New
We need the ability to pre-populate App questions with a default value. This not only gives the user an example of what type of data string the App is looking for, but also may avo ...
Posted By: michael.team
Posted On: 09/09/2014 10:56 AM
Comments: 0
Category: Analytic Appliances
Status: New
2014 Shipping and Gallery Data Update Schedule
Posted On: 09/05/2014 09:36 AM
Category: 
I have a project with a test tool connected to data streams that go to 3 separate output tools.  If the test fails, output is only blocked to one of the three output tools.  The ou ...
Posted By: jgreene
Posted On: 09/02/2014 10:42 AM
Comments: 7
Category: Developer
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: 08/29/2014 09:13 AM
Comments: 0
Category: Join
You can call me new school, but when I browse for inputs etc. in Alteryx, they are the old school windows interface where I have to hunt and peck through the file directory.  Can y ...
Posted By: sean.otto
Posted On: 08/28/2014 02:12 PM
Comments: 3
Category: Common Use Cases
Status: Under Review
Dear Alteryx,

Alteryx 9 new Macro configuration module, is great
One thing that could be improved :

For Iterative macros, it's very frustrated to set a Maximum of Iterations ...
Posted By: arnaud.langlois
Posted On: 08/28/2014 01:50 PM
Comments: 1
Category: Macros
Status: Not Planned
This should be quite easy to implement. I think it would be great if could we have:

1. A User repository for macros in the Users folder, e.g. My Documents\My Alteryx Macros\

This ...
Posted By: chris.love
Posted On: 08/28/2014 01:44 PM
Comments: 0
Category: Macros
Status: Coming Soon
For example, in the Properties tool (I say that generally because it could be in more than one place in that tool) all the user to enable to visibly see the path of the variable in ...
Posted By: sean.otto
Posted On: 08/28/2014 10:14 AM
Comments: 0
Category: Common Use Cases
Status: Under Review
When workig on a module with many tools, and one of those tools is the Allocate Input tool (Experian US), whenever you try to access or configure that other tools, there is a delay ...
Posted By: mbarone
Posted On: 08/28/2014 09:57 AM
Comments: 1
Category: Calgary
Status: Planned
I have several modules that need to run in sequence.   Can a ksh or some other program be used to string the modules together?  

So that if I have Step1.yxmd, Step2.yxmd and Step3 ...
Posted By: jmoney
Posted On: 08/28/2014 09:51 AM
Comments: 7
Category: Troubleshooting
Status: Under Review
If we rename a field ‘X’ to ‘Y’  in the alteryx module, the renaming is not inherited by all the tools using that field in that module. The tools which are still using the old fiel ...
Posted By: shashi.lingaiah
Posted On: 08/28/2014 09:44 AM
Comments: 0
Category: Preparation
Status: Under Review
In the ‘Report – Table’ tool I would like to be able to force headings to multiple lines. For example If I have a heading such as “Catchment (%)” or “Spend (£)”, I would like there ...
Posted By: joe.lipski
Posted On: 08/28/2014 09:43 AM
Comments: 0
Category: Reporting
Status: Under Review
A client contacted us recently asking if there was a way to view the log file of a scheduled process during runtime.  The use case is so that if there is a runaway process, they wi ...
Posted By: cmartin
Posted On: 08/28/2014 09:42 AM
Comments: 1
Category: Developer
Status: Under Review
The field selection pane in Multi-Field Formula is very small and not resizeable. It is difficult to select anything other than all variables when only 4 1/2 fields are displayed a ...
Posted By: tom.montpool
Posted On: 08/28/2014 09:41 AM
Comments: 0
Category: Preparation
Status: Under Review
I think that it would be useful to add two new Rename Modes to the Dynamic Rename tool -- here are the existing ones:


I would add:
Take Field Metadata from Right Input Metadata
T ...
Posted By: tom.montpool
Posted On: 08/28/2014 09:39 AM
Comments: 2
Category: Developer
Status: Under Review
Leverage Oauth 2.0 security protocol for the Alteryx salesforce.com connector
Posted By: adrian.boeh
Posted On: 08/27/2014 02:57 PM
Comments: 3
Category: Connectors
Status: Under Review
Hey all,

I have built a module that reads in a very long Word doc (1800+ page) to extract certain pieces of data that I'm interested in bringing into a table.  Some data is fo ...
Posted By: jbednarz
Posted On: 08/27/2014 01:24 PM
Comments: 2
Category: Parse
Hi all! 

I want to customize the Interface Designer tabs to add pictures or logos in order to improve the UI. 

Anyone know how to do this? 
Posted By: sakenk
Posted On: 08/27/2014 01:01 PM
Comments: 1
Category: Analytic Applications
Imagine I have 10 dimensions and 1 measure.
The dimensions are such items as "Region", "Country", "State", "City", "Zip", "Ac ...
Posted By: michael_nealey
Posted On: 08/27/2014 12:09 PM
Comments: 1
Category: Data Investigation
How do I set up MongoDB as the database type under the persistence section of the System Settings? A list of thorough instructions including how to install and configure MongoDB as ...
Posted By: andrew.komaromy
Posted On: 08/26/2014 10:24 PM
Comments: 1
Category: Common Use Cases
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: 
Add an option to read directly from a zip file.
Posted By: joe.strellis
Posted On: 08/24/2014 11:52 PM
Comments: 1
Category: In/Out
Status: Under Review
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 AlteryxDataAlteryx EngineAddress
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: DataInput OutputTroubleshootingAlteryx 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: SpatialReporting
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: Alteryx EngineInput OutputTransformIn 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: Getting Started with AlteryxAlteryx EngineTips and Tricks
FAQ: Q1 2014 Core Data Bundle Release
Posted On: 06/19/2014 02:15 PM
Category: Demographic Analysis
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: 06/11/2014 03:31 PM
Category: MacrosAlteryx Engine
How To: Prepare a Network Data Install
Do you find yourself running out of space while trying to install the latest Alteryx dataset? Have you considered a network data install to conserve space? There are several reas ...
Posted On: 06/08/2014 11:00 PM
Category: InstallationAlteryx Engine
The Alteryx Analytic Gallery Can Now Handle Zip Files!
Do you utilize a .tab file format for your spatial data? Now you have the ability to upload the .tab suite of files as one single .zip file!
Posted On: 05/21/2014 04:46 PM
Category: Alteryx WebAnalytics GalleryAnalytic Apps macrosAnalytic ApplicationsAlteryxWeb