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,

Can some one please let me know how to change the data field type to multiple variables in the select or join tools?  I want to be able to select multiple fields and change th ...
Posted By: mani.vannan
Posted On: 08/01/2014 01:58 PM
Comments: 1
Category: Preparation
Hi,

Can some one please let me know how to change the data field type to multiple variables in the select or join tools?  I want to be able to select multiple fields and change th ...
Posted By: mani.vannan
Posted On: 08/01/2014 06:51 AM
Comments: 0
Category: Preparation
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: 07/31/2014 11:00 AM
Comments: 2
Category: Developer
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: 07/31/2014 10:09 AM
Comments: 0
Category: Preparation
Status: New
I have often thought it would be nice to have a 'predicted run time' for a module calculated.

An adequate prediction might be the complete run time last time the module ra ...
Posted By: elanser
Posted On: 07/31/2014 06:13 AM
Comments: 0
Category: Tips and Tricks
Status: New
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: Getting Started with AlteryxInstallationDataAlteryx EngineAddress
Hi,

I am a new user.  When I have warnings during a run, how do i see those warnings?  Looks like there is some out put setting for a log file.  Can anyone help me do this setting ...
Posted By: mani.vannan
Posted On: 07/29/2014 12:28 PM
Comments: 1
Category: Tips and Tricks
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/29/2014 09:04 AM
Comments: 3
Category: Parse
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: 07/29/2014 08:29 AM
Comments: 0
Category: Macros
Status: New
Hi

I need to copy a file from one server to another and then process the file . Is there a way to do it?

Thanks
Posted By: evelyn.sherwin
Posted On: 07/29/2014 06:30 AM
Comments: 2
Category: Preparation
Is there a way to use Detour in a programmatic way? I would like to bypass a set of tools if a condition in my data is met. For example, bypass a Sort in a Macro if the count of re ...
Posted By: gioel.molinari
Posted On: 07/28/2014 08:10 PM
Comments: 3
Category: Tips and Tricks
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/28/2014 06:51 PM
Comments: 8
Category: Data Investigation
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/28/2014 11:02 AM
Comments: 1
Category: Macros
Hi Guys

Hope you can help me with this query...

I have a date as a string with the format dd/mm/yyyy . In order to convert this to a date I used the datetime tool with the format ...
Posted By: evelyn.sherwin
Posted On: 07/28/2014 02:28 AM
Comments: 4
Category: Transform
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/26/2014 06:40 PM
Comments: 2
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
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: TroubleshootingIn OutInput OutputDataAlteryx Engine
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: 2
Category: Common Use Cases
Status: New
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
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
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: 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
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
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
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 macrosAnalytics GalleryAlteryx WebAnalytic Applications
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: Analytic Apps macrosGetting Started with AlteryxTips and TricksAlteryx Engine
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 AlteryxAlteryx EngineLicenses 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: Tips and TricksAnalytic ApplicationsQuick Start GuidesCommon Use CasesGetting 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: Data InvestigationCommon Use CasesAlteryx EngineGetting Started with AlteryxAnalytic Apps macrosMacrosAnalytic Applications
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: DeveloperAlteryx EngineGeneral
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: Alteryx EngineAnalytic Apps macrosInput OutputConnectors
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: DataData InvestigationAlteryx EngineAddress
2014 Shipping and Gallery Data Update Schedule
Posted On: 03/21/2014 04:06 PM
Category: