Working with Nested and Hierarchical Data
Best practices for working with structured formats like JSON and XML, including flattening, normalization, and transformation techniques.
Flatten and Normalize Nested Documents
- Working with Nested Documents and Formats in Etlworks
- Nested mapping
- 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