Use of the 'flatten' transformation in the Vega Lite app and format for array-valued data

[Nose_Croquet]

Hi,

Has anyone successfully used the ‘flatten’ transformation described here:

Vega-Lite

Flatten

Vega-Lite - a high-level grammar for statistical graphics. Vega-Lite provides a higher-level grammar for visual analysis, comparable to ggplot or Tableau, that generates complete Vega specifications. Vega-Lite specifications consist of simple...

to transform array data that’s in an Airtable field? I’m trying to transform some data without having to specify the field names ahead of time, so I’m wondering if I can somehow represent it as an array.

This is a bit of a kludge, because there isn’t an ‘array’ datatype in Airtable (AFAIK). I suspect I might have to manually specify the format somehow, because just putting it in a text field like this:

[1,2,3]

doesn’t seem to produce the results you might expect.