Julie Sebby

How to Create a Rank in Alteryx

This is the third time in about 6 weeks that I’ve needed to create a rank in Alteryx and couldn’t remember how. Each time I had to dig through projects to find what I did last time. That means it’s time to write it up so I can find it next time. Read more to learn an easy way to create a rank in Alteryx.

Read More »How to Create a Rank in Alteryx

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 – 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

Using the Then Keyword

At the end of last week’s post, I promised to continue with examples of all node navigation methods. But, I have decided to wrap up keywords first. Thus, this week’s post will explain how to use the “Then” keyword. Then is incredibly useful in Spotfire because it allows you to specify the order of calculations in an expression. In other words, “calculate this and THEN calculate that”. However, there are a few places you can get tripped up. Read on to learn more.

Read More »Using the Then Keyword