The loop describes your action flow, not code to paste into a JavaScript node. Replace the sample literals with your query fields. Reset optional fields on every iteration so values do not carry over from the previous row.
[
{
"Key": "region-0-month-1",
"XKey": "month-1",
"YKey": "region-0",
"Value": 42000,
"IsMissing": false
},
{
"Key": "region-0-month-2",
"XKey": "month-2",
"YKey": "region-0",
"Value": 44940,
"IsMissing": false
},
{
"Key": "region-0-month-3",
"XKey": "month-3",
"YKey": "region-0",
"Value": 47880,
"IsMissing": false
},
{
"Key": "region-0-month-4",
"XKey": "month-4",
"YKey": "region-0",
"Value": 50820,
"IsMissing": false
},
{
"Key": "region-0-month-5",
"XKey": "month-5",
"YKey": "region-0",
"Value": 53760,
"IsMissing": false
},
{
"Key": "region-0-month-6",
"XKey": "month-6",
"YKey": "region-0",
"Value": 56700,
"IsMissing": false
},
{
"Key": "region-1-month-1",
"XKey": "month-1",
"YKey": "region-1",
"Value": 33500,
"IsMissing": false
},
{
"Key": "region-1-month-2",
"XKey": "month-2",
"YKey": "region-1",
"Value": 35845,
"IsMissing": false
},
{
"Key": "region-1-month-3",
"XKey": "month-3",
"YKey": "region-1",
"Value": 38190,
"IsMissing": false
},
{
"Key": "region-1-month-4",
"XKey": "month-4",
"YKey": "region-1",
"Value": 40535,
"IsMissing": false
},
{
"Key": "region-1-month-5",
"XKey": "month-5",
"YKey": "region-1",
"Value": 42880,
"IsMissing": false
},
{
"Key": "region-1-month-6",
"XKey": "month-6",
"YKey": "region-1",
"Value": 45225,
"IsMissing": false
},
{
"Key": "region-2-month-1",
"XKey": "month-1",
"YKey": "region-2",
"Value": 25000,
"IsMissing": false
},
{
"Key": "region-2-month-2",
"XKey": "month-2",
"YKey": "region-2",
"Value": 26750,
"IsMissing": false
},
{
"Key": "region-2-month-3",
"XKey": "month-3",
"YKey": "region-2",
"Value": 28500,
"IsMissing": false
},
{
"Key": "region-2-month-4",
"XKey": "month-4",
"YKey": "region-2",
"Value": 30250,
"IsMissing": false
},
{
"Key": "region-2-month-5",
"XKey": "month-5",
"YKey": "region-2",
"Value": 32000,
"IsMissing": false
},
{
"Key": "region-2-month-6",
"XKey": "month-6",
"YKey": "region-2",
"Value": 33750,
"IsMissing": false
},
{
"Key": "region-3-month-1",
"XKey": "month-1",
"YKey": "region-3",
"Value": 16500,
"IsMissing": false
},
{
"Key": "region-3-month-2",
"XKey": "month-2",
"YKey": "region-3",
"Value": 17655,
"IsMissing": false
},
{
"Key": "region-3-month-3",
"XKey": "month-3",
"YKey": "region-3",
"Value": 18810,
"IsMissing": false
},
{
"Key": "region-3-month-4",
"XKey": "month-4",
"YKey": "region-3",
"Value": 19965,
"IsMissing": false
},
{
"Key": "region-3-month-5",
"XKey": "month-5",
"YKey": "region-3",
"Value": 21120,
"IsMissing": false
},
{
"Key": "region-3-month-6",
"XKey": "month-6",
"YKey": "region-3",
"Value": 22275,
"IsMissing": false
}
]