Working with mixed structures
This section focuses on structured values that contain structures of a different type. Although a wide range of scenarios is possible, we cannot possibly illustrate them all; however, this section should provide enough insight into how to tackle the most common challenges you are likely to encounter.
Lists of tables, lists, or records
As demonstrated earlier, handling a list of items that share a consistent structure and are grouped together can easily be managed and converted to a table. This approach is incredibly powerful and applies equally to working with a single column in a table or converting lists in every table row in a table to reshape the data.
Let’s explore the first scenario, dealing with columns that contain structured values. Imagine a table organized in the following manner:
- Table values
- List of lists, where each inner list represents column values
- List of lists, where each inner list represents...
