Data Merger

Left Dataset (JSON)

Right Dataset (JSON)

Merge Key

Merge Strategy

Example Input

Left Dataset:

[
  {
    "id": 1,
    "name": "John Doe",
    "department": "IT"
  },
  {
    "id": 2,
    "name": "Jane Smith",
    "department": "HR"
  }
]

Right Dataset:

[
  {
    "id": 1,
    "salary": 75000,
    "location": "New York"
  },
  {
    "id": 3,
    "salary": 65000,
    "location": "Chicago"
  }
]

Merge Strategies:

Inner Join: Only keep records that match in both datasets
Left Outer Join: Keep all records from left dataset, matching right where possible
Right Outer Join: Keep all records from right dataset, matching left where possible
Full Outer Join: Keep all records from both datasets