Alteryx

WeeklyAlteryxTips#38 Load the data to the Database by PreSQL

This post is about loading the data to the database. When you adopt the Alteryx Server, you can use schedule function. I...
Alteryx

WeeklyAlteryxTips#37 The difference between the count of the Summarize tool and the Count Records tool

I think this is the famous tips. Which tool do you use the Summarize tool or Count Records tool when you want to count t...
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. Question Supposed to create a field with the same name but with a numeric type, by using the Formu...
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...
Alteryx

WeeklyAlteryxTips#33 The easy way to see the necessary Spatial Object on the Map

When you proceed the spatial analytics, the spatial fields will increase more and more. So, it often make you confused. ...
Alteryx

WeeklyAlteryxTips#32 Create a random point in the polygon

This post is about Spatial function. How to create a random point by Alteryx Designer You might want to create many rand...
Alteryx

WeeklyAlteryxTips#31 How to determine the numeric value or not in the string type field

I would like to think of a way to determine only numeric type records in a string type field. This is a sample data. Sup...
Alteryx

WeeklyAlteryxTips#30 How to use the IS function

This post is also about Alteryx function, especially IS functions. IS function There are some "Is" function in Alteryx. ...
Alteryx

WeeklyAlteryxTips#29 How to write an IF statement in an easy-to-understand manner part2

This post is also about function. I will explain how to make the complex IF statement easier to understand. First I prep...