Hey everyone,
I'm trying to figure out how to flatten the "anonymous" (no key, only values) structured data within the "trend_in" element of the json below.
Is it possible to use the Flatten Array component in a way that references only the index position of the array? For example producing a table like:
pos1, pos2, pos3
1672160401, 1672164001, 8
1672135201, 1672138801, 0
... and so on
Source json:
{
"camera_address": "123 Main St, Parker, CO 80134, USA",
"camera_id": "blahblah",
"camera_name": "Int 08 (4k)",
"camera_site": "CO - 204 Parker",
"end_time": 1672256095,
"org_id": "blahblah",
"org_name": "My Company",
"start_time": 1672131601,
"trend_in": [
[
1672131601,
1672135201,
0
],
[
1672135201,
1672138801,
0
],
[
1672138801,
1672142401,
0
],
[
1672142401,
1672146001,
0
],
[
1672146001,
1672149601,
0
],
[
1672149601,
1672153201,
0
],
[
1672153201,
1672156801,
0
],
[
1672156801,
1672160401,
9
],
[
1672160401,
1672164001,
8
],
[
1672164001,
1672167601,
6
],
[
1672167601,
1672171201,
11
],
[
1672171201,
1672174801,
8
]
],
"type": "person"
}