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:

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: 07/24/2014 07:57 AM
Comments: 1
Category: Data Investigation
I am wondering if anyone has connected Alteryx to a graph database in Neo4j in order to run queries in the Cypher query language. There is a JDBC driver available but thats no good ...
Posted By: gioel.molinari
Posted On: 07/23/2014 05:20 PM
Comments: 1
Category: Connectors
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: 07/23/2014 06:10 AM
Comments: 0
Category: Data Investigation
Hi,
I have a record set with a  date field called date_attended with other information and I would like to generate a row if a row is missing in a month .For example, If the date_a ...
Posted By: evelyn.sherwin
Posted On: 07/23/2014 02:28 AM
Comments: 2
Category: Transform
We have Created a macro for Fuzzy match for two files(.xlsx). Macro is supposed to take two files as input and perfom a match.
It performs the fuzzy match only on the embeded file ...
Posted By: udaykatagouni
Posted On: 07/23/2014 12:18 AM
Comments: 0
Category: Macros
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: 07/22/2014 06:40 AM
Comments: 1
Category: In/Out
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: 07/22/2014 06:40 AM
Comments: 0
Category: In/Out
Status: New
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: Input OutputTroubleshootingDataAlteryx EngineIn Out
My team is developing an Alteryx application to be published to the Alteryx gallery. This application will leverage R packages not installed in the custome R Alteryx install. The p ...
Posted By: paul
Posted On: 07/21/2014 02:06 PM
Comments: 3
Category: Analytic Applications
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: 07/21/2014 08:11 AM
Comments: 0
Category: Calgary
Status: New
When developing a module, I generally BROWSE the final data until I'm ultimately ready to generate output.  Then I need to add or replace a browse tool with an output tool.  Pe ...
Posted By: mark.frisch
Posted On: 07/21/2014 08:01 AM
Comments: 0
Category: In/Out
Status: New
I have a time series of values that i want to upsample or downsample by either filling forward or filling backward and i would like to set a limit for the maximum 'lookback' ...
Posted By: gioel.molinari
Posted On: 07/18/2014 07:47 PM
Comments: 2
Category: Tips and Tricks
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: 07/18/2014 09:16 AM
Comments: 0
Category: Common Use Cases
Status: New
Hello, this is my first post in the Alteryx community and I am super new.

I am looking to parse a series of Text files from Opensecrets.org

Each file is in .txt format, with comm ...
Posted By: nhara
Posted On: 07/17/2014 03:09 PM
Comments: 1
Category: Parse
I got to know that in version 9.1 Alteryx will have Unique Tool with "Unknow"check box to make it dynamic. I want to suggest same logic for Summarize tool for making it D ...
Posted By: pratikg
Posted On: 07/17/2014 09:31 AM
Comments: 0
Category: Developer
Status: New
In the Browse window: Can we add a Find function like in excel? (e.g. find record_ID==4 or name =='foobar') Can we click the column name so it sorts on that field? I ...
Posted By: sphwillis
Posted On: 07/16/2014 09:56 AM
Comments: 0
Category: Common Use Cases
Status: New
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: 07/16/2014 09:40 AM
Comments: 4
Category: In 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: 
Hi ,

I am a beginer in Alteryx and I would like to know how to exclude the last three records in my excel file . Please note,the files I need to process has variable number of rec ...
Posted By: evelyn.sherwin
Posted On: 07/15/2014 09:07 AM
Comments: 4
Category: Preparation
Hi

I am trying to join 2 inputs but rather on matching items I want to join based on a value in input 1 being between 2 value in input B (or >= to the first value in input 2 an ...
Posted By: nick.lupis
Posted On: 07/14/2014 06:06 AM
Comments: 3
Category: Join
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/13/2014 07:46 AM
Comments: 3
Category: Join
I want to rank a long list of records that contains groups and sub-groupings. The ranking would be based on each sub-group (e.g. 'Top 3 Products Purchased per Customer'). I ...
Posted By: davidteter
Posted On: 07/11/2014 11:51 AM
Comments: 4
Category: Preparation
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: 07/11/2014 05:44 AM
Comments: 2
Category: In Out
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/10/2014 09:40 AM
Comments: 3
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/10/2014 09:37 AM
Comments: 1
Category: In Out
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
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
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:
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: Input OutputAlteryx EngineTransformIn 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
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
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
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: 1
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
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
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
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
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
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: Getting Started with AlteryxLicenses and ActivationAlteryx Engine
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 GuidesAlteryx EngineGetting Started with Alteryx
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: GeneralDeveloperAlteryx Engine
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: 
Rating:
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 EngineData InvestigationAddress
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: