core.noscript.text
We got a question via the forums: Hi, I'm trying to output to Excel, but a number of fields in my data contain only Null values and I want to exclude these.
Sometimes data comes in to Alteryx in an unexpected code page. One example recently is Tele Atlas started shipping their data in SHP files that are UTF-8 encoded.
Note: Sorry about the technical difficulties with my earlier posting attempt.I was asked by a client to create a module to generate a map for each of their trade areas which are ma...
With Alteryx 5.0 and the new toolbox, there is a new tool folder called: Developer Tools. What is it and why is it called that?The 1st question that c
I got a feature request asking for the ability to ask a question. In the end, the module in question sends an email. They want to prompt the user with
There was a question on the Alteryx forums today about reading multiple XLS tables. This is the kind of thing that the DynamicInput tool is designed f
To start at the end, the source code associated with this article can be found at the end of this post. The projects are all built with VS 2005.I have
Before I get to today's post, I want to talk a little about Bill's recent post. Polar graphs are not for everyone, but what is really interesting abou
Now that Alteryx 5.0 is finally out the door, my team and I finally have a chance to breath. Once again, the team did an amazing job. I believe that A
In mathematics, the polar coordinate system is a two-dimensional coordinate system in which each point on a plane is determined by a distance from a f
It is official... Alteryx 5.0 was released on Friday November 20, 2009. It is on its way to our devoted users and loaded with new features and functionality.
It's been a long time since our last blog post. The core team is extremely busy working towards Alteryx 5.0. I hesitate to give an exact date, but we
We got the following customer request:We work with a ton of different input files in various formats, etc...and sometimes have poor documentation on w
From several customer requests, we have add a new set of financial functions to the formula library. Mostly the functions are copies of what Excel has
The Directory tool is very simple and small, but it can really come in handy - especially with the Batch Macros. All it does it read a list of files f
It seems like a very straight forward thing to do - comparing numbers. It ends up much more complicated than people think. The problem is that 2 numbe
Have you ever gotten someone's module and had to change each and every input and output path because they were set to a different directory than you h
We members of the data team crunch a LOT of numbers! Sometimes, our modules run agonizingly slow, so we decided it was time to review our best practic
With Alteryx 5.0, currently in beta, there is a new tool - Dynamic Rename. The tool will allow users to quickly rename fields through multiple methods
The Calgary engine within Alteryx has allowed very fast queries, but it has had the limitation that it can only refer to a single data table. This can
I have gotten the question of how to count records in a stream. The simplistic answer is to use a summarize tool. That works in most situations, but t
Is it just another case of "ours goes up to 11"? Actually no - there are some very real reasons for 64 bit with Alteryx. It allows us to use more m
As sometimes happens I needed to change a database password. It's a pretty straight forward process: log into your database server, find the login, ch
Last week, SRC held its annual Extend user conference at the Omni Resort in Broomfield, Colorado. This year we put on an Alteryx Grand Prix to showcas
How do we build & test Alteryx? Thanks to Linda, we have a nice script that runs the Alteryx build every night, but building it is not enough. We
I had the pleasure of helping test a module for the Alteryx Grand Prix and learned a number of things. But the most interesting? Mod.Mod?Mod.Wikipedia
I have been spending a lot of time lately working on Unicode issues. Mostly I have been making our older products like Allocate & Solocast fully work
Last week I sent an email to our Alteryx users asking for participation in a short survey to help us plan and prioritize features for the 5.0 release
One of the latest additions to Alteryx, available in an upcoming beta release, is the ability to express spatial objects as variable length strings. T
General rule of thumb...anytime you find yourself having to replicate what seems to be the same process, there is an easier way to automate it. Rec