Preparation Category

Alteryx

WeeklyAlteryxTips#60 How to count date

In this article, I would explain the way to count days between start date and end date.For example, supposed to want to ...
Alteryx

WeeklyAlteryxTips#58 How to sort the fields?

I would like to consider sorting the fields.Sort fields staticallyIf you want to sort fields by alphabet order, you can ...
Alteryx

WeeklyAlteryxTips#57 How to impute missing values

Missing values are always a headache to prepare data. Let's consider the way to handle the missing data.Replace null dat...
Alteryx

WeeklyAlteryxTips#53 All about the Ranking

There are several ways to rank the records. The simplest way is to sort the records in ascending/descending order, ranki...
Alteryx

WeeklyAlteryxTips#50 Detecting errors in Alteryx Part3

This post is subsequent of the previous post, which is about error detecting in Alteryx. This is based on the same use c...
Alteryx

WeeklyAlteryxTips#47 Incorporating randomness to the Alteryx workflow

I would like to explain how to incorporate randomness to the Alteryx workflow. This post is inspired by the Weekly Chall...
Alteryx

WeeklyAlteryxTips#36 Dynamic Data Type Conversion

This post is about how to change the data type dynamically. But the case what I handle on this post is about a special c...
Alteryx

WeeklyAlteryxTips#35 How to update the value with changing the field type

This is a basic tips.QuestionSupposed to create a field with the same name but with a numeric type, by using the Formula...
Alteryx

WeeklyAlteryxTips#34 The difference between the Date Time Now tool and DateTimeNow() function

When you want to get the current day and time, you can use the Date Time Now tool or the DateTimeNow() function on the F...