Flatten and Normalize Nested Documents
Learn how to flatten nested arrays and objects, normalize hierarchical datasets into tabular format, and extract data using SQL or transformations. Use these techniques when loading JSON, XML, or API responses into relational databases or CSV.
- 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
- Flatten nested dataset using Extract Dimensions transformation
- Flatten source XML with repeating segments