AlteryxのTipsを週一で公開するコーナーです。
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...
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. ...
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...
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...
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, ...
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...
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 ...
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...
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...
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...