Transforming data in Alteryx can ensure that the dataset best fits the needs of how the output data should be analyzed. In this chapter, you'll learn the pivot orientations of the Transpose and Crosstab tools and how they help to guide the pathway to a visual representation of your data. Once your data has been aligned to meet business needs, you will dive into summarizing and aggregating your data to perform various numeric and string actions.
This chapter will cover the following topics:
- Transforming data
- Summarizing and aggregating data
- Running total
- Weighted average