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:

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: 04/18/2015 01:29 PM
Comments: 2
Category: Alteryx University
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: 1
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
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: 04/16/2015 10:55 AM
Comments: 0
Category: In/Out
Status: New
Sorry this question is so basic.

When I select "Show Output Window" nothing happens. In the past I've seen the output window; it just disappeared after a restart. Wh ...
Posted By: sarmstrong
Posted On: 04/15/2015 09:58 AM
Comments: 0
Category: Tips and Tricks
Hi Folks,

I'm new to Alteryx and not able to figure this one out yet and looking for help/advice.

I've a module that reads from a CSV file , transpose data and save to a ...
Posted By: rkallingal
Posted On: 04/14/2015 08:09 AM
Comments: 1
Category: Analytic Applications
I have few subworkflows starts with an input components within a module. How do I control the sequence of the execution of each subworkflow?
Posted By: dhydrated
Posted On: 04/14/2015 05:50 AM
Comments: 4
Category: Connector
Hi,
I would like to be able to repurpose workflows that share common functions across different projects. It would save a lot of time if I could globally edit the name of a field i ...
Posted By: sarmstrong
Posted On: 04/13/2015 04:14 PM
Comments: 2
Category: Tips and Tricks
Hi,

Let's say there are two set of folders - for modules in development and and modules in production.

is there an good way to have the same module but depending on environme ...
Posted By: borys.tyukin
Posted On: 04/13/2015 11:59 AM
Comments: 0
Category: Developer
I'm getting an error when using the Dynamic Replace tool: "Parse Error at char(18): Unmatched Quote". Here's the formula for the replace: [_CurrentField_]==" ...
Posted By: susan
Posted On: 04/11/2015 10:08 AM
Comments: 1
Category: Parse
Hi, 

I've been exploring about controller and worker since the last few days. I was able to push workflows to worker through controller and it ran. However I have couple of qu ...
Posted By: siddartha.reddy
Posted On: 04/10/2015 03:20 PM
Comments: 1
Category: Common Use Cases
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: 04/09/2015 01:38 PM
Comments: 1
Category: Tips and Tricks
When setting up an email in the Events tab of a module, the default body of the email is %OutputLog% which provides all the messages written to the Output tab.
Are there any option ...
Posted By: sandy.pettinger
Posted On: 04/09/2015 01:33 PM
Comments: 0
Category: In Out
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/09/2015 08:14 AM
Comments: 0
Category: Data Investigation
Status: New
I'd like to reserve port 80 on my server for a reverse proxy that Alteryx Server would sit behind.  Anything off the box could still connect using 80, but locally I'd like ...
Posted By: rick.piankajr
Posted On: 04/08/2015 01:35 PM
Comments: 0
Category: Installation
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
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: 04/06/2015 12:13 AM
Comments: 1
Category: In Out
Hi,

I am trying to convert the below data into another format with another ID, For example, the first row should become "1001]3001]" (i.e. the ID will be different every ...
Posted By: tyler.pun
Posted On: 04/05/2015 08:04 PM
Comments: 1
Category: Transform
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
Hello,

I need to output excel data to separate excel files that use the same excel template.

I was able to output my data into separate excel files using tutorial 1.

However, wh ...
Posted By: eblee
Posted On: 04/03/2015 01:40 PM
Comments: 0
Category: In Out
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/02/2015 11:11 AM
Comments: 2
Category: Data Investigation
Status: New
Hi there, 
I have a large (2GB) CSV file, and unfortunately for some reason the first 3 rows contain some notes. The headers are in row 4, and the data is all below that. Is there ...
Posted By: buchanan.ben
Posted On: 04/01/2015 01:13 PM
Comments: 3
Category: Help Docs Tutorials
Geohash is a latitude/longitude geocode system (public domain). It is a hierarchical spatial data structure which subdivides space into buckets of grid shape.

Geohashes offer pro ...
Posted By: ben.stroud
Posted On: 04/01/2015 11:57 AM
Comments: 0
Category: Spatial
Status: New
It would be nice if we could use our gallery with a mobile app. We like to run demographics on site and have to pull up on the ipad.

Also, if instead of typing in an address, we c ...
Posted By: hpippin
Posted On: 04/01/2015 10:46 AM
Comments: 0
Category: Tips and Tricks
Status: New
I have a user who has a batch macro set up for processing customer records as they relate to stores. The macro loops based on the storeID. In some cases, some stores do not have cu ...
Posted By: alloyd
Posted On: 03/31/2015 08:04 AM
Comments: 0
Category: Macros
Status: New
Hello all,

My requirement is to calculate year on year sales. I am having records with every month as a header. I need to calculate yoy sales, sum of latest 12 months minus sum of ...
Posted By: jeeva.ganesan
Posted On: 03/30/2015 02:49 PM
Comments: 3
Category: Transform
I have the Show Properties Window selected, but it is not showing up on my screen. At first I thought it was just hidden and that I could just pull it back from being hidden, but I ...
Posted By: jeffrey.lefeld
Posted On: 03/30/2015 01:26 PM
Comments: 1
Category: Troubleshooting
Status: New
Is support for Amazon Web Services DynamoDB available or in the works?
Posted By: ben.stroud
Posted On: 03/30/2015 08:35 AM
Comments: 0
Category: Connectors
I need to take two excel files, each with multiple tabs, and combine them into one file, keeping all the tabs seperate (and possibly renaming tabs, if possible). Is this an availab ...
Posted By: sh0711
Posted On: 03/30/2015 08:20 AM
Comments: 0
Category: Reporting
Hello All,

Can you add the flexibility to access fields based on its position or index like a[1], a[2],... a[n]. a[1] being the first column. Also an option to get max[a] can give ...
Posted By: jeeva.ganesan
Posted On: 03/30/2015 03:14 AM
Comments: 0
Category: Transform
Status: New
When I set the width of my columns in my table, it doesn't actually change the width at all. I've tried automatic, percentage, and fixed and nothing changes the width of th ...
Posted By: sh0711
Posted On: 03/29/2015 11:12 PM
Comments: 1
Category: Reporting
Can you add an ExceptionHandler to the Tile Tool? The tool crashed on a large dataset.  I got an Error: Tile (1): No values found before GetMean() on the tile tool. I selected Smar ...
Posted By: sphwillis
Posted On: 03/27/2015 03:52 PM
Comments: 0
Category: Developer
Status: New
I'd love the ability to Input an already-formatted Print Layout area within an Excel document, or a .PDF document in an effort to standardize reports needed on a regular basis. ...
Posted By: jalbertini
Posted On: 03/27/2015 02:43 PM
Comments: 1
Category: In/Out
Status: Under Review
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: 03/27/2015 02:42 PM
Comments: 2
Category: Analytic Appliances
Status: Under Review
In my environment, creating tables with fields in a particular order is a requirement.

The Select tool (and others) let me manually change sort orders. The Select tool will also a ...
Posted By: tom.montpool
Posted On: 03/27/2015 02:42 PM
Comments: 3
Category: Common Use Cases
Status: Not Planned
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: 03/27/2015 02:41 PM
Comments: 1
Category: Troubleshooting
Status: Under Review
I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields.  Currently they are not recognized as spatia ...
Posted By: brian.wiedower
Posted On: 03/27/2015 02:39 PM
Comments: 1
Category: In/Out
Status: Under Review
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: 03/27/2015 02:39 PM
Comments: 2
Category: Predictive
Status: Now Available
I would like to use the precreate statement as part of a app. That means if a user selects ID '12345' from an interface tool, I would like to delete recs in SQL server with ...
Posted By: sphwillis
Posted On: 03/27/2015 02:38 PM
Comments: 2
Category: In/Out
Status: Under Review
This question is related to the behavior of the Output Data tool.

When creating CSV output with Code Page option set to Unicode UTF-8 the output file contains a byte order sequenc ...
Posted By: ben.stroud
Posted On: 03/26/2015 12:49 PM
Comments: 2
Category: In Out
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
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: 02/18/2015 06:18 AM
Category: GeneralAlteryx serverGetting Started with Alteryx
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: Legal TemplatesData documentation
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 macrosData documentationAlteryx EngineGetting Started with Alteryx
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: 
Transferring A License With Alteryx v9.1 And Above
Are you getting a PC upgrade for your Alteryx development? Now licenses can be uninstalled and reinstalled from one machine to the other! Click through for more details.
Posted On: 01/05/2015 12:03 PM
Category: Alteryx EngineAlteryx analytics gallery
Macro Debugging: Use Another Macro!
Do you develop custom macros using Alteryx? Try the X-Ray Macro to help with debugging!
Posted On: 12/11/2014 03:11 PM
Category: 
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: Products
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: Alteryx analytics galleryAlteryx designerAlteryx serverData documentation
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: 
2014 Shipping and Gallery Data Update Schedule
Posted On: 10/03/2014 03:02 PM
Category: 
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 EngineAll