Book Image

Alteryx Designer Cookbook

By : Alberto Guisande
Book Image

Alteryx Designer Cookbook

By: Alberto Guisande

Overview of this book

Alteryx allows you to create data manipulation and analytic workflows with a simple, easy-to-use, code-free UI, and perform fast-executing workflows, offering multiple ways to achieve the same results. The Alteryx Designer Cookbook is a comprehensive guide to maximizing your Alteryx skills and determining the best ways to perform data operations This book's recipes will guide you through an analyst's complete journey, covering all aspects of the data life cycle. The first set of chapters will teach you how to read data from various sources to obtain reports and pass it through the required adjustment operations for analysis. After an explanation of the Alteryx platform components with a particular focus on Alteryx Designer, you’ll be taken on a tour of what and how you can accomplish by using this tool. Along the way, you’ll learn best practices and design patterns. The book also covers real-world examples to help you apply your understanding of the features in Alteryx to practical scenarios By the end of this book, you’ll have enhanced your proficiency with Alteryx Designer and an improved ability to execute tasks within the tool efficiently
Table of Contents (17 chapters)

Inputting Data from Files

As data workers, no matter how mature and evolved your actual working environment is, you’ll have to deal with a good number of files and different formats, even when they refer to the same kind of data.

Through the years, I’ve seen a lot of analysts struggling with the same problems, such as vendor files that are not consistent, structure changes through versions of the same file, and so on.

In this chapter, we’ll start defining recipes for those common situations you’ll encounter when reading files using Alteryx Designer.

We’ll read multiple Excel files from a single directory, multiple worksheets from an Excel file, and multiple Excel files having different structures between worksheets. Specifically, we’ll look at the following recipes:

  • Reading a worksheet from multiple Excel files all at once
  • Reading all worksheets from an Excel file all at once—same schema
  • Different schema Excel...