Transforming JSON to Tables: the Impedance Problem
This is a note from 2022 I found by accident today. Teaser: It will become relevant again, soon, so I want to share the rough idea with you today. JSON data containing nested object lists within object lists, namely, arrays of objects within other arrays, cannot be mapped directly to a 2D table representation.