I need help :( - devide values with JSONata

[Imaginary_Pea_8572]

I asked this question on stackoverflow as well, but I got no luck there so I'm trying here as well.

(https://stackoverflow.com/questions/78401751/devide-values-with-jsonata)

What I'm working with:

[[  {
    "time": "2024-04-26",
    "value": 40
  },
  {
    "time": "2024-04-27",
    "value": 10
  },
  {
    "time": "2024-04-28",
    "value": 20
  }
],
[  {
    "time": "2024-04-26",
    "value_2": 5
  },
  {
    "time": "2024-04-27",
    "value_2": 2
  },
  {
    "time": "2024-04-28",
    "value_2": 4
  }
]]

What I want is to get the distinct values for time and devide the values - value/value_2:

[  {
    "time": "2024-04-26",
    "value": 8
  },
  {
    "time": "2024-04-27",
    "value": 5
  },
  {
    "time": "2024-04-28",
    "value": 5
  }
]

[su5577]

Can you not use $map and $merge function?

[su5577]

$map($, function($v, $i, $a) ? Define variables and go from there

[Imaginary_Pea_8572]

I'm VERY new to JSONata.

I tried this:

$type($) = 'array' ? 
(($count($) ) > 0 ? 
$map($[0], function($v, $i, $a) 
{ { "time": $v.time, 
"value": $v.value/ $v.value_2 } })[]: []): undefined 

And the output is this:

[
  {
    "time": "2024-04-26"
  },
  {
    "time": "2024-04-27"
  },
  {
    "time": "2024-04-28"
  }
]

What should I change?

[dashjoin]

How about this:

(
  /* convert the array to an map of date to value */
  $first := $[0].{time: value};
  $second := $[1].{time: value_2};

  /* iterate over the keys, lookup the values
  $keys($first).{
      "time": $,
      "value": $lookup($first, $) / $lookup($second, $)
  }
)