Merge List of Dictionary using ansible

I am trying to merge two list of dictionaries.

"my_name": 
[ {
"name": "xyz",
"number": "123" },
{
"name": "abc",
"number": "456"
}
]


"my_address":
[ {
"name": "abc",
"address": "smith street" },
{
"name": "xyz",
"number": "ray street"
}
]

Required Output:

merged:

[ {
"name": "abc",
"address": "smith street",
"number": "456" },
{
"name": "xyz",
"address": "ray street",
"number": "123"
}
]

I tried using combine but it would just combine the last item.

set_fact:
  merged: "{{ my_name | combine(my_address) }}"

"merged":
[
{
"name": "xyz",
"number": "ray street",
"number": "123"
}
]

i used the debug module. debug: msg: "{{ my_name| list_mergeby(my_address,'name')}}" The error was: template error while templating string: no filter named 'lists_mergby,

For example, given the fixed my_address

- hosts: localhost

  vars:

    my_name:
      - name: xyz
        number: '123'
      - name: abc
        number: '456'

    my_address:
      - name: abc
        address: smith street
      - name: xyz
        address: ray street

    merged: "{{ [my_name, my_address]|community.general.lists_mergeby('name') }}"

  tasks:

    - debug:
        var: merged

gives (abridged)

  merged:
  - address: smith street
    name: abc
    number: '456'
  - address: ray street
    name: xyz
    number: '123'

See: the filter community.general.lists_mergeby