Subarray Key Labelled Rows Report Builder

How it works

1. 1.Run the manual trigger to emit the fictional sample object with named subarrays and edge-case fields
2. 2.A Code node scans object keys and emits one row per array element with label, position and original values
3. 3.A Set node orders label, position and source_values while retaining other fields
4. 4.A parallel Code node sums subarray lengths and merges with the rows
5. 5.An IF node compares counts: match passes through NoOp, mismatch builds a deviation report naming both numbers
6. 6.A final Code node aggregates everything into a single report item

Use cases

• Flattening JSON objects with named subarrays into one labelled report table
• Auditing split integrity by comparing row count to summed array lengths
• Preparing source-labelled rows for downstream analysis or export

Requirements

• n8n version 2.44.4
• No external credentials and no network calls
• Replace the sample object inside the loader Code node with real data of the same schema for production use

Setup and testing in n8n

1. Import into n8n 2.44.4, execute manually, expect one report with status ok and five rows
2. Verify labels_present equals exactly invoices and shipments
3. Edge test: empty an array or force a count mismatch and expect a deviation report naming both numbers
4. A valid empty source produces an ok report with zero rows; an invalid source produces a deviation report with the reason. Verify unique source positions.

Service Value

Ready-made workflow template for automation delivery and service execution.