The Alteryx Community is getting a makeover!

We are hard at work making major improvements to the Alteryx Community with a brand new platform. Trust us when we say, it is going to be great!
As we work on migrating content to the new platform, you will no longer have the ability to submit new ideas, comments or questions until we re-launch the community in early September. Hold on to those, we’ll want to see them once the new community is live!
If you require product support during this period, please send an email to clientservices@alteryx.com
Thanks for your patience and stay tuned for more information as we get closer to the re-launch date of the new community.

Category:

August 2015 CASS engine re-release
Posted On: 08/26/2015 01:37 PM
Category: Data documentationNew Releases
Q1 2015 US Spatial Data Bundle
Posted On: 08/24/2015 04:44 PM
Category: Data documentation
Q1 2015 US Core Data Bundle
Posted On: 08/24/2015 04:41 PM
Category: Data documentation
Q1 2015 CA Spatial Data Bundle
Posted On: 08/24/2015 04:40 PM
Category: Data documentation
Q1 2015 CA Core Data Bundle
Posted On: 08/24/2015 04:37 PM
Category: Data documentation
Hey guys,

To set the scenario, I have a list (column) of product codes, and around 200 column headers of customer names. The values consist of how many of those products each cust ...
Posted By: ydogan1989
Posted On: 08/14/2015 07:52 AM
Comments: 1
Category: Preparation
Hello


how do i test a column for business day minus one and reject if it is not that date

many thanks

Denny
 
Posted By: denny.chan
Posted On: 08/14/2015 03:11 AM
Comments: 0
Category: In Out
Hello! 

Could anyone tell me the reason MapServer Error happens sometimes like as below?
Is there anyway to prevent this MapServer Error?


Many thanks.

Kazu
Posted By: k.koebisawa
Posted On: 08/14/2015 12:18 AM
Comments: 0
Category: Troubleshooting
2015 Shipping and Gallery Schedule
Posted On: 08/13/2015 04:28 PM
Category: Demographic AnalysisSpatial
Hi,

How can I connect to Microsoft CRM Online?


Regards,
Jag
Posted By: jagjit.singh
Posted On: 08/13/2015 05:43 AM
Comments: 0
Category: Connectors
Hello! 

Could anyone tell me the way to add a referense map?

Many thanks.

Kazu
Posted By: k.koebisawa
Posted On: 08/13/2015 12:33 AM
Comments: 0
Category: Spatial
I am building some forecast models and I need to change the X and Y axis of the output graph for a better visualisation. Basically, i would like to know, how to modify the scale of ...
Posted By: wahmed
Posted On: 08/12/2015 02:56 PM
Comments: 0
Category: Tips and Tricks
I used the download tool to get data from http://api.stlouisfed.org/fred
The download was successful but it failed when I am within company network. 
The error message is 

HTTP/1. ...
Posted By: emily.qixiao
Posted On: 08/12/2015 11:47 AM
Comments: 1
Category: Connectors
Hello

I have a process that Schedules files, through Alteryx, the files will need to be worked on once, is there a way to move / kill the source file once the process has complete ...
Posted By: denny.chan
Posted On: 08/12/2015 06:56 AM
Comments: 1
Category: In Out
I have many use cases that involve one or more of the following: moving or renaming a file after importing itdeleting a file after importing itmoving or copying a file after succes ...
Posted By: rob.cottrell
Posted On: 08/11/2015 11:53 AM
Comments: 2
Category: Developer
Status: Under Review
I was recently surprised to find that Alteryx doesn't already havea connector to upload to SFTP sites.  I've managed to work around it with RunCommand and some external pro ...
Posted By: rob.cottrell
Posted On: 08/11/2015 11:52 AM
Comments: 0
Category: In/Out
Status: Under Review
When a tool's input connector is already attached to a data stream that only accepts a single connection, attempting to attach a 2nd data stream with the same fields should aut ...
Posted By: rob.cottrell
Posted On: 08/11/2015 11:51 AM
Comments: 1
Category: Common Use Cases
Status: Under Review
Can we move the "Save" disc that's above the tool ribbon to someplace that is not so easily clicked?  Maybe by icons that aren't used as frequently used as the ne ...
Posted By: chris_cleckner
Posted On: 08/11/2015 11:38 AM
Comments: 1
Category: Developer
Status: Under Review
I have a Azure SQL Server Database and I'm trying to use Alteryx's new In-database tools.  Unfortunately, I've run into a problem.  It appears that the in-Database Stre ...
Posted By: mutuelinvestor
Posted On: 08/10/2015 07:13 PM
Comments: 0
Category: Troubleshooting
Hello gurus - 

Let's say I've got a .xls file that contains flattened data that I really want to push into a more appropriate relational structure.  So, say, for each row ...
Posted By: brian.scott
Posted On: 08/10/2015 01:19 PM
Comments: 0
Category: Transform
Hi,

I need to use Pre SQL Statement to update values of a column using values from one of my fields in the workflow. Sonething like this ....

update table
set columnA = [fieldnam ...
Posted By: pgandhi
Posted On: 08/07/2015 07:40 AM
Comments: 0
Category: In Out
Hello Community,

I was wondering if it's possible not to lose information about how many records and size each connection node pulled. When workflow finished the visualisation ...
Posted By: dawid.nawrot
Posted On: 08/07/2015 02:39 AM
Comments: 0
Category: Tips and Tricks
Hi, Gurus,

I need help on merging different INPUT excel sheets into the same OUTPUT excel sheets, for example sheet1 and sheet2.

I searched the old post:
1. where  blockunitldone ...
Posted By: wendy.lu
Posted On: 08/06/2015 04:33 PM
Comments: 0
Category: In Out
Hi, Gurus,

I need help on merging different INPUT excel sheets into the same OUTPUT excel sheets, for example sheet1 and sheet2.

I searched the old post:
1. where  blockunitldone ...
Posted By: wendy.lu
Posted On: 08/06/2015 04:29 PM
Comments: 0
Category: In Out
I have a filter which sometimes results in True condition and sometimes in False. I want to stop the False part from running when the conidition is true and vice versa. What I have ...
Posted By: pgandhi
Posted On: 08/05/2015 05:06 PM
Comments: 5
Category: Preparation
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: 08/05/2015 07:40 AM
Comments: 7
Category: In Out
Hi,

I have a field with date being written as 'Thursday, July 30, 2015 12:00pm EDT', how do I go about converting it to a standard date time format with timezone informati ...
Posted By: pgandhi
Posted On: 08/04/2015 12:32 PM
Comments: 0
Category: Parse
Hi,

I'm working on using an Alteryx workflow to publish reports to an internal Tableau server. Attempting to extract the Visual Analytics Kit for Tableau gives me errors with ...
Posted By: sonal.dighe
Posted On: 08/04/2015 06:38 AM
Comments: 2
Category: Troubleshooting
I need to consume a web service that uses a “0-legged” OAuth transaction. I contacted Alteryx tech support and found that this was not possible with the current feature set of the ...
Posted By: jhollingsworth
Posted On: 08/03/2015 02:51 PM
Comments: 0
Category: Connectors
Status: New
Is there a tool to dynamically create a new file directory on the hard drive (or network drive); whereby the file directory name would be a field in the incoming data, and the file ...
Posted By: patrick.mcauliffe
Posted On: 08/02/2015 06:21 PM
Comments: 1
Category: In Out
A Gini index provides a measure of diversity for a particular continuous or catagorical variable.  It is usually used to measure concentration of wealth or income.  There are some ...
Posted By: j_brzezinski
Posted On: 08/02/2015 06:11 PM
Comments: 1
Category: Macros
I use detours to bypass areas when I do not need them in the loop and it would be great if i just had a enable button (kind of like how you would control in a macro).  That way i d ...
Posted By: anthony
Posted On: 07/28/2015 01:18 PM
Comments: 0
Category: Developer
Status: New
At TargetSmart, we create a lot of CSV deliverables for our customers. Since Alteryx differentiates between blank strings and null values (a good thing), the CSV output is not cons ...
Posted By: ben.stroud
Posted On: 07/28/2015 08:13 AM
Comments: 1
Category: In/Out
Status: New
Every time I add a tool container I default the Margin to "none." Could you make a default selection part of user settings? Thank you.
Posted By: gregory.w.hall
Posted On: 07/25/2015 09:48 AM
Comments: 0
Category: Developer
Status: New
Sometimes I get conversion error messages or warnings that really don't matter, and it would be great if there was a function similar to spell check or grammer check where I co ...
Posted By: cbridges
Posted On: 07/22/2015 11:41 AM
Comments: 0
Category: Reporting
Status: New
I know you can add a field for "today" and then use that field to append the filename, so the output ends up as Ouput_Date.xlsx, but it would be great to be able to do th ...
Posted By: cbridges
Posted On: 07/22/2015 09:06 AM
Comments: 2
Category: In/Out
Status: New
The capability to input/output R Datasets via the input/output tools, together with all the other data formats as well (like csv, Excel, SAS, SPSS, etc).
Posted By: santiago.restrepo
Posted On: 07/10/2015 02:10 PM
Comments: 3
Category: In/Out;Predictive
Status: Under Review
I would like to see the same functionalitly that the Output Tool has in the Render tool.  In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you ...
Posted By: don.searls
Posted On: 07/09/2015 07:30 AM
Comments: 1
Category: Reporting
Status: New
I have used the SharePoint List Connectors with our SharePoint 2010 (on prem) instance for some time now. It works great and has become invaluable. Unfortunately, I have been told ...
Posted By: castropn
Posted On: 07/08/2015 08:08 AM
Comments: 0
Category: Connectors
Status: New
Hi 

Wanted to control the order of execution of objects in Alteryx WF but right now we have ONLY block until done which is not right choice for so many cases 

Can we have a con ...
Posted By: s.pichaipillai
Posted On: 07/08/2015 03:52 AM
Comments: 5
Category: Developer
Status: New
Very nice to be able to extend Alteryx with R programs or CMD execution.  Please, please, please add a connection to Python!
Posted By: _anthony.brown
Posted On: 07/06/2015 07:12 AM
Comments: 0
Category: Connectors
Status: New
Configurable hotkeys/keyboard shortcuts would be awesome.  For instance, select/deselect highlighted fields or remove prefix are two commands that I use frequenctly but which are b ...
Posted By: _anthony.brown
Posted On: 07/06/2015 07:06 AM
Comments: 0
Category: Common Use Cases
Status: New
I know this has been suggested before, but it would be great if calculations and transformations could be cached between workflow executions.  Perhaps the browse tools could be con ...
Posted By: _anthony.brown
Posted On: 07/06/2015 07:01 AM
Comments: 0
Category: Common Use Cases
Status: New
default file path in "File Browser" interface app would be a nice to have feature. Similar to what we have in Numeric, Text etc. interface app.
Posted By: shailesh_patel
Posted On: 07/02/2015 12:45 PM
Comments: 1
Category: Tips and Tricks
Status: Under Review


Within the mapping tool, please add an alignment option (left/center/right) within the label options (when wrapping).
Posted By: alteryx
Posted On: 07/02/2015 12:44 PM
Comments: 1
Category: Reporting;Spatial
Status: Under Review
Would be great if we could right click on an input and in addition to having "convert to macro input" there was an option for "convert to dynamic input".
Posted By: patrick.mcauliffe
Posted On: 07/02/2015 12:43 PM
Comments: 2
Category: In/Out
Status: Under Review
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: 06/26/2015 02:48 PM
Category: Alteryx server
What Does The Connection Info Actually Mean?
Have you ever wondered what the file size in the connection between two tools actually means? Click through to find out!
Posted On: 06/23/2015 03:15 PM
Category: 
Inspire 2015: Tips & Tricks
Inspire 2015 Tips & Tricks PDF document
Posted On: 06/02/2015 07:26 AM
Category: 
In-Database Processing FAQ
Click through for an in-depth FAQ around the new In-Database tools!
Posted On: 05/27/2015 02:24 PM
Category: 
Webinar Training Module: Tips and Tricks (Dec 13)
Attached is the module created during the Tips and Tricks public webinar recorded December 2013.
Posted On: 04/27/2015 04:05 AM
Category: Data documentation
Alteryx Certified Module Requirements
Posted On: 04/27/2015 04:05 AM
Category: Getting StartedAlteryx server
Using the Tool Container
This will overview the Tool Container tool and its functions.
Posted On: 04/27/2015 04:05 AM
Category: All
Southern California Alteryx User Group meeting on Tuesday October 29, 2013 2-4:30pm
Join us for our next Southern California Alteryx User Group meeting on Tuesday, October 29, 2013 from 2-4:30 pm PST
Posted On: 04/27/2015 04:05 AM
Category: Professional services
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: 04/27/2015 04:05 AM
Category: Getting Started with AlteryxData documentationAlteryx Engine
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: 04/27/2015 04:05 AM
Category: Alteryx EngineAll
Batch Macros: An Example
We often come across a situation that calls for a macro. Many users are unfamiliar with why they would use a different type of macro, so Ned, our CTO has written a blog post about ...
Posted On: 04/27/2015 04:05 AM
Category: Analytic Apps macrosAlteryx EngineAll
How To: Use Alteryx To Connect To Google Analytics
By now you are probably aware that Alteryx has the ability to connect to many different cloud services. This article touches on a series of two YouTube video tutorials explaining ...
Posted On: 04/27/2015 04:05 AM
Category: 
Alteryx Partner Technical Training Guide- Module 1 Managing Data
Alteryx Partner Technical Training Guide Module 1 - Managing Data 1(a)- Parsing 1(b)-Basic Data Blending
Posted On: 04/27/2015 04:05 AM
Category: Data CleansingData ProcessingData documentationAlteryx EngineGetting Started
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: 04/21/2015 10:24 AM
Category: Getting Started with AlteryxGeneralAlteryx server