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 have a long dataset with a column filled with "University XYZ" and "University XYZ (10002345)" where the bit in brackets is added for 1 year of data only. I w ...
Posted By: p.kevill
Posted On: 07/10/2014 02:47 AM
Comments: 1
Category: Parse
Hello,

Not sure if this is a simple item but was hoping to get a recommendation on a tool to help assign if an item is taxable or not based on a state and item code match.  Fo ...
Posted By: kpurcell
Posted On: 07/09/2014 01:18 PM
Comments: 0
Category: Join
I'm attempting to use the generate row tool to populate a field with date ranges. 

I've juggled the settings around and here several times and am only able to generate eit ...
Posted By: danwalls
Posted On: 07/09/2014 10:28 AM
Comments: 2
Category: Preparation
I attempted to input an xlsx file with over 3400 columns, but the Input tool only captured the first 255 columns. I know that .xls files was limited to that amount of columns, but ...
Posted By: jimmy.romogo
Posted On: 07/09/2014 08:01 AM
Comments: 0
Category: In Out
I am trying to combine multiple KML (Google Earth) files into 1 file (either KML or something else)   I do this via the Directory tool and the Dynamic Input tool.    This ...
Posted By: hans
Posted On: 07/09/2014 06:34 AM
Comments: 4
Category: Preparation
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: 07/08/2014 11:53 AM
Comments: 1
Category: In Out
Our team works with a lot of in-house transaction data sets that have been put into a calgary database.  It would be much easier to build apps that use the calgary input tool witho ...
Posted By: chris_cleckner
Posted On: 07/08/2014 06:07 AM
Comments: 0
Category: Analytic Appliances
Status: New
Currently when I open and run an app in designer mode im unable to access any other modules while it runs.  It would be nice to be able to work on other modules while an app runs w ...
Posted By: chris_cleckner
Posted On: 07/08/2014 05:59 AM
Comments: 0
Category: Analytic Appliances
Status: New
Add an option to read directly from a zip file.
Posted By: joe.strellis
Posted On: 07/08/2014 01:23 AM
Comments: 1
Category: In/Out
Status: New
I have a question that my input .xlsx file has a formula =IF(BA658=0,0,AM686/BA658). Which have shown the value 0.
But when i fetched the file in to alteryx. It also show value 0 b ...
Posted By: ashiques
Posted On: 07/07/2014 04:36 AM
Comments: 2
Category: In Out
One of my customers was asking how to convert a date in JDE Julian format to an Alteryx date format.

In the comment following this, I have the answer I provided for him.
Posted By: rlight
Posted On: 07/03/2014 02:13 PM
Comments: 1
Category: Preparation
Hi,

Just got Alteryx Licenses for Designer and Designer+data. I got the license keys for both of them. When I try to install them I get these options. How do I find out which of t ...
Posted By: naveen.jain
Posted On: 07/03/2014 12:17 PM
Comments: 1
Category: Licenses and Activation
I have created a batch macro in Designer. However, each iteration needs to run on a separate Excel sheet in a single workbook. Is there a way within Alteryx to access individual sh ...
Posted By: michael.treadwell
Posted On: 07/03/2014 08:52 AM
Comments: 1
Category: Macros
It would be nice to have the ability to double click the top area of a container to either show or hide the container's objects. Only being able to show or hide containers usin ...
Posted By: brian.kasen
Posted On: 07/02/2014 01:47 PM
Comments: 0
Category: Tips and Tricks
Status: New
I think a great functionality addon would be a tool that could allow one to impute dates.  While the formula tool and multi-row tool can in many cases assist, it is not useful when ...
Posted By: nicholas.carstens
Posted On: 07/02/2014 06:56 AM
Comments: 1
Category: Preparation
Status: New
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:
1) I have a batch macro and a module which run the macro. But when i run the Module it takes 25 sec to run the process. So is there any way to cut that time. It is very urgent requ ...
Posted By: ashiques
Posted On: 07/01/2014 07:16 PM
Comments: 2
Category: Macros
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: TransformAlteryx EngineInput OutputIn Out
My Alteryx is version 9.0, 64x and I'm having this error opening other's Alteryx module:
"There is an error opening.... : Data at the root level is invalid. Line 1, po ...
Posted By: wang.maria
Posted On: 06/30/2014 08:04 AM
Comments: 1
Category: Common Use Cases
Reading .xlsx Into Alteryx Sometimes Has Issues
We often get cases where a user reports an issue with reading .xlsx files. There are two primary cases, the first of which is being able to see the file format for .xlsx in the In ...
Posted On: 06/27/2014 09:51 AM
Category: TroubleshootingInput OutputDataAlteryx EngineIn 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
Receiving this error. Does this mean a client is closing before everything can be loaded. Or is the file too big. It's an excel file.
Posted By: mreinsch
Posted On: 06/24/2014 02:36 PM
Comments: 1
Category: In Out
Receiving this error. Does this mean a client is closing before everything can be loaded. Or is the file too big. It's an excel file.
Posted By: mreinsch
Posted On: 06/24/2014 01:44 PM
Comments: 0
Category: In Out
Receiving this error. Does this mean a client is closing before everything can be loaded. Or is the file too big. It's an excel file.
Posted By: mreinsch
Posted On: 06/24/2014 01:44 PM
Comments: 0
Category: In Out
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: 06/24/2014 01:20 PM
Comments: 0
Category: Common Use Cases
Status: New
Hi,

I have installed Alteryx 9 on my desktop but as my company has a proxy, I cannot register my email address. Alteryx raise an error "An internet connection is required.... ...
Posted By: thierry.chauvier
Posted On: 06/24/2014 05:46 AM
Comments: 2
Category: Installation
As well as having the play and stop button in think it would be useful to have a pause button.
Posted By: joe.strellis
Posted On: 06/24/2014 01:49 AM
Comments: 0
Category: Common Use Cases
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: 06/20/2014 03:00 PM
Comments: 1
Category: In Out
Instead of being a module setting, showing counts should/could be a user setting.
Posted By: mark.frisch
Posted On: 06/20/2014 08:56 AM
Comments: 0
Category: Common Use Cases
Status: New
FAQ: Q1 2014 Core Data Bundle Release
Posted On: 06/19/2014 02:15 PM
Category: Demographic Analysis
Seeing how we use browse to tools to help build out modules, but they slow down the modules because they write out temp files, it would be awesome to have a "record count" ...
Posted By: chris_cleckner
Posted On: 06/18/2014 10:55 AM
Comments: 2
Category: Data Investigation
Status: New
Salesforce reports are easy to create in Salesforce, but to reproduce them using Alteryx's connector is 1) near impossible given the complex children/parent relationships, 2) l ...
Posted By: jeremy.dalletezze
Posted On: 06/18/2014 07:44 AM
Comments: 0
Category: Connectors
Status: New
When building an expression (e.g. [Store Type] in ("Supermarket", "C-Store", "Gas Station") ) when the user selects the field variable, provide all th ...
Posted By: michael.team
Posted On: 06/17/2014 02:21 PM
Comments: 0
Category: Common Use Cases
Status: New
When working with a transactional API, it would be beneficial to allow for multiple threads to process the workload concurrently.  A single threaded consumption is a good start, bu ...
Posted By: mark.frisch
Posted On: 06/17/2014 07:11 AM
Comments: 0
Category: Developer
Status: New
I'm currently trying to categorize some text by using the regex match function. An example of matching could be:

"there is a hole in the door"

In two seperate opera ...
Posted By: niho
Posted On: 06/12/2014 01:19 PM
Comments: 1
Category: Join
When running modules that start with Access database Inputs, it takes much longer to make the connection.  This did not happen with 8.6.  Wonder if anyone else has reported this.
Posted By: mbarone
Posted On: 06/11/2014 03:37 PM
Comments: 1
Category: In Out
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: Alteryx EngineMacros
WIth the 9.0 release, I've notice that it takes quite a bit longer for the engine to pull up the UI window for ODBC connections (meaning the window that show you the tables, th ...
Posted By: mbarone
Posted On: 06/11/2014 09:11 AM
Comments: 7
Category: In Out
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: Alteryx EngineInstallation
Provide the ability to leverage data "Connectors" as an option in the "Dynamic Input" tool.
Posted By: jeremy.dalletezze
Posted On: 06/08/2014 01:54 PM
Comments: 0
Category: Developer
Status: Under Review
As there is a DateTimeFirstOfMonth() Formula function is there any reason why there is not or could not be a DateTimeFirstOfWeek() equivilant.

Thanks,
Joe
Posted By: joe.lipski
Posted On: 06/08/2014 01:53 PM
Comments: 2
Category: Preparation
Status: Under Review
For many of us who use Alteryx to transform sensitive data, the Gallery is only a potential liability.  While Alteryx was able to disable the Gallery for us through a custom soluti ...
Posted By: hamiltonnr
Posted On: 06/08/2014 01:52 PM
Comments: 0
Category: Licenses and Activation
Status: Planned
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: AlteryxWebAnalytic Apps macrosAnalytic ApplicationsAlteryx WebAnalytics Gallery
I'm a long time user of Photoshop and it would be great to get some similar zooming and panning functionality into Alteryx.  Such as:

- hold down the "space bar" ...
Posted By: sean.otto
Posted On: 05/18/2014 11:39 AM
Comments: 1
Category: Tips and Tricks
Status: Now Available
Ability to adjust the underlying speeds on the roadways via the GUI and eliminate having to modify the xml file and registry OR adjust the existing speeds in Guzzler that correspon ...
Posted By: dketza
Posted On: 05/18/2014 11:38 AM
Comments: 0
Category: Spatial
Status: Under Review
Currently on the input tool I can only specify if the first row contains data.  It would be great if I could simply specify which row the data starts on, ie. row 4 or row 500, and ...
Posted By: sean.otto
Posted On: 05/18/2014 11:37 AM
Comments: 3
Category: Common Use Cases
Status: Under Review
Allow the artisan to turn off the ability of a member to download app results.  Some of the information is highly confidential, and we don't want them to be able to easily prin ...
Posted By: mbarone
Posted On: 05/18/2014 11:37 AM
Comments: 0
Category: Analytic Appliances
Status: Under Review
Alteryx 9.0 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: 05/08/2014 11:40 AM
Category: Alteryx EngineGetting Started with AlteryxAnalytic Apps macrosTips and Tricks
I would like to be able to load large amounts of data into my MSSQL database using a faster interface.
Posted By: bgomez
Posted On: 05/04/2014 09:38 PM
Comments: 1
Category: Connectors
Status: Now Available
What's New In Alteryx 9.0: Licensing
Licensing and activation is taking a turn for the better with Alteryx 9.0. We've consolidated a few things to make licensing more robust and easier to use!
Posted On: 04/30/2014 02:49 PM
Category: Alteryx EngineGetting Started with AlteryxLicenses and Activation
What's New In Alteryx 9.0: App & Macro Authoring
One of the most recognizable changes to Alteryx 9.0 is the way you will author Analytic Apps and Macros. Say hello to the new Interface Tools!
Posted On: 04/24/2014 10:37 AM
Category: Analytic ApplicationsTips and TricksCommon Use CasesQuick Start GuidesGetting Started with AlteryxAlteryx Engine
What's New In Alteryx 9.0: An Overview
There are many things that will look familiar in Alteryx 9.0, but there are also many new features. Changes to app and macro authoring, wireless connections, and a host of new con ...
Posted On: 04/24/2014 09:47 AM
Category: MacrosData InvestigationCommon Use CasesAlteryx EngineGetting Started with AlteryxAnalytic ApplicationsAnalytic Apps macros
Using the Dynamic Replace Tool
Ever wonder what those Dynamic Tools are actually used for? Turns out, they may be exactly what you are looking for! In this article, we will cover the Dynamic Replace Tool. In ...
Posted On: 04/15/2014 01:12 PM
Category: Alteryx EngineGeneralDeveloper
My Salesforce Connector Is No Longer Working, What Do I Do?
Did your module or app using the Salesforce Connector tool suddenly stop working? Salesforce just updated their API, which ultimately changed the way our Salesforce Connector tool ...
Posted On: 04/08/2014 01:02 PM
Category: Input OutputAnalytic Apps macrosAlteryx EngineConnectors
Q4 2013 Core Data Bundle Documentation
Posted On: 04/01/2014 08:49 PM
Category: DataData Investigation
Latest Alteryx Customer Advisory e-Forum Recording and Slides Now Available!
Click through for the latest Alteryx Customer Advisory e-Forum recording and Powerpoint slides.
Posted On: 04/01/2014 08:59 AM
Category: 
Post Office Changes Allow Street Addressed Mail To Be Delivered To P.O. Boxes
Recent changes to how the United States Postal Service operates now allow for a business to use the actual address of a post office as their own. How does this affect Alteryx?
Posted On: 03/25/2014 04:09 PM
Category: DataAlteryx EngineAddressData Investigation
2014 Shipping and Gallery Data Update Schedule
Posted On: 03/21/2014 04:06 PM
Category: 
eCAB Meeting August 2013
This article provides a link to the eCAB meeting held August 2013
Posted On: 03/11/2014 05:27 PM
Category: Getting Started
Rating:
User Question: How Does the Smart Tile Feature Work?
Many processes in Alteryx utilize the Tile Tool, which has the ability to tile a set of records a number of different ways. One such method is Smart Tile, which utilizes a simple ...
Posted On: 03/04/2014 08:57 AM
Category: GeneralAlteryx EngineGetting Started with AlteryxPreparation