9

Dynamic Operations

We saw the power of the Dynamic tools, or at least one of them, in Chapter 1, Recipe 2 – Read a worksheet from multiple Excel files all at once – same schema different folders/subfolders, in Chapter 2, Recipe 5 – Access and determine which files to be processed from a file repository, and in Chapter 2, Recipe 1 – Cursor behavior, but more efficiently when we used the Dynamic Input tool to read the contents of several inputs all at once and to create a more efficient cursor behavior over databases.

In this chapter, we’ll explore several recipes using Dynamic tools to perform powerful dynamic operations over data.

These operations include the following:

  • Renaming fields dynamically based on dictionaries, conditions, or even ...

Get Alteryx Designer Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.