I have a data object like this :

```
{
  "data1": [
    [
      "ID",
      "name",
      "Birthday"
    ],
    [
      "10",
      "thomas",
      "1992-03-17"
    ],
    [
      "11",
      "Emily",
      "2000-03-03"
    ]
  ],
  "data2": [
    [
      "Balance",
      "ID"
    ],
    [
      "$4500",
      "10"
    ],
    [
      "$1500",
      "13"
    ]
  ]
}

```

It contains two arrays `data1` and `data2`.
The first row in each array is the name of the columns and the rest of the rows have the data (think of it like a table).

I want to compare the `ID` field in both arrays and if the `ID`s match then the final output will contain a column `Balance` with the balance corresponding to that `ID` and if the `ID`s don't match then the `Balance` will be `$0`.

Expected output:

```
{
  "output": [
    [
      "ID",
      "name",
      "Birthday",
      "Balance"
    ],
    [
      "10",
      "thomas",
      "1992-03-17",
      "$4500" //ID 10 matched so the balance added here
    ],
    [
      "11",
      "Emily",
      "2000-03-03",
      "0" //0 bcoz the ID 11 is not there in data2 array
    ]
  ]

}

```

I find this challenging to accomplish. Think of it like a LEFT-JOIN in MySQL.
I referred to this [solution](https://stackoverflow.com/questions/32965688/comparing-two-arrays-of-objects-and-exclude-the-elements-who-match-values-into) but it doesn't work in my case as I don't have the keys in my response.

**EDIT**: I also need to join the other fields as well.