Skip to content

Blog

Using the ‘In’ Operator in Alteryx Filter Tools

I promise to resume my Spotfire expression series, but… This week, I will showcase 2 Alteryx tips and tricks I learned from coworkers last week. The first will be a salute and fond farewell to my teammate Alice Yu who is leaving the company. I am very sad to see Alice depart, as she is the light of our team and an all-around good and fun human. The second will be a warm welcome to Jack Stewart who is moving from our Geo team to the Analytics team. I can already tell that Jack approaches problems very differently from me, so I expect to learn a lot from him. So, with that said, here is what I learned from Alice….

Read More »Using the ‘In’ Operator in Alteryx Filter Tools

How to Control the Order of Operations in Alteryx

One of the things I love about Alteryx is how fast it pushes data through a workflow. However, sometimes, we need to run one part of a workflow before another. In other words, we want to control the order of operations in Alteryx. I knew the application could do this, but to incorporate it into my workflow, I had to learn a few new tools. Read on to learn which tools allow you to control the order of operations in a workflow.

Read More »How to Control the Order of Operations in Alteryx

Node Navigation – Parent & ParallelPeriod

This is post 9 in my series on how to learn the Spotfire expression language. It explains the Parent and ParallelPeriod node navigation methods. Originally, I included NavigatePeriod, but NavigatePeriod deserves its own post, so it will follow next week. Read on to learn about Parent and ParallelPeriod node navigation methods.

Read More »Node Navigation – Parent & ParallelPeriod

Node Navigation – FirstNode, LastNode, LastPeriods, PreviousPeriod & NextPeriod

This is post 8 in my series on learning the Spotfire expression language. We are in the middle of exploring all of the node navigation methods. This post will cover FirstNode, LastNode, LastPeriods, PreviousPeriod and NextPeriod. I’m combining these particular methods in order to differentiate between Node, Period, and Periods. Read on to learn the difference.

Read More »Node Navigation – FirstNode, LastNode, LastPeriods, PreviousPeriod & NextPeriod

How to Create A Dynamic Query in Alteryx

The more I learn about Alteryx, the more I love it as a tool for data wrangling. I recently had 2 use cases pop up where I needed to be able to dynamically change the data being queried. I knew the application could perform this task, but I hadn’t yet learned how to create a dynamic query in Alteryx. Now that I know how I’m writing it up for future reference and other people to use. Two use cases are presented because they are configured differently. Read on to learn how.

Read More »How to Create A Dynamic Query in Alteryx

Node Navigation – All, Next, Previous, AllNext & AllPrevious

This is post 7 in my series on how to learn the Spotfire expression language. In my node navigation post, I explained what a node is, what node navigation is used for, and provided examples. But, I didn’t provide explanations or examples for each method. Now, I will fill that gap by explaining the details of All, Next, Previous, AllNext & AllPrevious.  Others to follow. 

Read More »Node Navigation – All, Next, Previous, AllNext & AllPrevious