Transforming Data
No matter how you start working with your data, it’ll need to be transformed. Extracting/parsing fields, breaking one column into many, transposing, and arranging data are very common and necessary operations when working with data.
In this chapter, we’ll see some useful methods to accomplish highly demanding tasks at ease so that your data is made ready for analysis.
Our main focus will be transposing (pivoting) and arranging data. Alteryx is very powerful and fast at performing these operations, which are crucial to correctly shape our datasets. We’ll be providing recipes for the following tasks:
- Pivoting (and un-pivoting) your data
- Fixing field names after a Cross Tab operation
- Laying out data in columns
- Arranging data
