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 data in the same file
- Select fields based on their metadata
- Replace contents dynamically based on expressions/conditions
- Building complex formula expressions from within your data
