Working with Nested and Hierarchical Data
Best practices for working with structured formats including flattening, normalization, and transformation techniques.
Nested data basics
Flatten and Normalize Nested Documents
- Mapping when the source is nested and destination is flat
- Use SQL to extract data from non-relational sources
- Normalize nested dataset as flat tables or files
- Another Way to Work with Nested API Responses: Output and Formatting Options in HTTP Connector
- Flatten nested dataset using Extract Dimensions transformation
- Flatten source XML with repeating segments