Wrap-up
1. Wrap-up
Congratulations! You've completed the course! Let's take a quick look at all you've accomplished.2. Formula tool
In chapter 1, you learned about your role as an analyst at Genesis LLC, and leveraged the formula tool for conditional statements such as IF, ELSEIF, and IIF. You also used operators such as AND, OR, and NOT for more complex logic. We touched on another function - CONTAINS, as well as the existence of many other functions in the function library. You also learned about using the expression editor, the color indicators in the text within it, and proper syntax.3. Transpose tool
In chapter 2, you learned how to pivot data using the transpose tool. We configured three sections to determine our outputs. Key columns, data columns, and missing columns. We learned that transpose always generates Name and Value columns, which can be renamed using a select tool.4. Cross tab tool
In chapter 3, you learned to unpivot and aggregate data using the cross tab tool. Configuring group data by these values, change column headers, values for new columns, and method for aggregating values.5. Next steps
If you're looking for some additional opportunities to further your learning, check out these resources!6. Congratulations!
Congratulations on all that you've learned, and stay curious out there as you continue your Alteryx journey!Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.