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...
Alteryx

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

When you think of the Alteryx, you probably think of it as a "Tool", but functions play a very important role in some to...
Alteryx

WeeklyAlteryxTips#27 How to know the bottleneck of the Alteryx Workflow in running speed

When you need to handle the huge data, you want to make the workflow which finish the processing quickly. In that case, ...
Alteryx

WeeklyAlteryxTips#26 How to get the data from the Table of Report

The principal component analysis is useful for dimensionality reduction. In the Alteryx, we can do PCA using the Princip...
Alteryx

WeeklyAlteryxTips#25 Change the width of the column with the Table tool

With the Table tool, you often want to decide the width of the column freely. At this post, let's see how to render the ...
Alteryx

WeeklyAlteryxTips#24 Merging cells with the Table tool part2

Continuing from last time, let's see the Table tool. This time, I would like to do the data part and for the header, use...
Alteryx

WeeklyAlteryxTips#23 Merging cells with the Table tool

Honesty, the Alteryx is not good at outputting the formatted Excel sheet by itself. For example, if you need 2 rows head...
Alteryx

WeeklyAlteryxTips#22 How to get the table list from SQL Server

This post is about database system. Recently, High-performance cloud data warehouse like Snowflake, BigQuery or Databric...
Alteryx

WeeklyAlteryxTips#21 Call the stored procedure in PostgreSQL

A stored procedure is a function that allows you to group together several database processes, save these processes in t...
Alteryx

WeeklyAlteryxTips#20 How to put the different Spatial Objects on a map of the same area using the Report Map tool

Sorry for the long title. This post means strictly that "How to put the some Spatial Objects have different positions on...