I usually see the data in the Result Window in Alteryx Designer. Do you know that you can manupulate the data in the Result Window?
Please try to click on the 3 points button at the column name in the Result Window.
To manupulate the data by drag and drop from tool pallete to the canvas is basic behavior, so I usually didn’t manupulate it in the Result Window. So, I realized this was possible when I saw some users who had recently started using Designer manipulating the data in the results window. Actually, the function of manipulating data is enabled since version 2019.3.
What can I do in the Result Window?
Data manupulation in the Result Window allows only some simple functions. You can use 3 functions as follows.
- Data Cleanse
- Filter
- Sort
Unfortunately the function is not implemented full functions of each Designer tool. You can use a part of each tool functions.
- Data Cleanse
- Replace Null Data
- Remove Unwanted Characters
- Modify Case
- Filter
- Basic Filter
- Sort *can’t sort by the Dictionary order
The good point of manupulating data in the Result Window
結果ウィンドウ内のデータは、データ量が多いとき（システム設定で変更が可能ですが、デフォルト1Mです）は省略されてしまいますが、もちろんその影響は受けてしまいます。ただ、閲覧ツールを使えば大きなデータであってもデータを表示可能なので、そのような際は結果ウィンドウ内でソートやフィルターなどの処理をしてしまえばわざわざワークフローを実行し直さなくても反映することができます。特にワークフローの処理内容が長くなって時間がかかるような場合は非常に有効な機能です。
このとき、複数の作業を行うことができます。
Furthermore, you can click on the green check button to apply these manupulation for the actual workflow.
Clicking on the apply button, the Designer put some tools as you manuplated in the Result Window.
Conclusion
- I have explained that you can use 3 functions in the Result Window.
- You can apply the result of the data manupulation to your actual workflow.
- To manupulate in the Result Windows is only one function that you can see the result of the data manupulation without running the workflow.
- It is very useful for debugging and adhoc data exploration.
By the way, the function of the Result Window in the Designer Cloud is much more improved than Designer Desktop. When you can use Designer Cloud, please try it!
The next blog post is…
The next post will be about how to find missing time data.
コメント