Project

General

Profile

Join

Description

Join two arrays on the specified fields

Input/Output

Array #1 : array <= Source
Field #1 : value <= Option
Array #2 : array <= Source
Field #2 : value <= Option

Output : array

Usage

  1. Connect a source to the operator
  2. Drag an array from the source tree and drop it into input field Array #1
  3. Select Field #1
  4. Click on OK
  5. Drag an array from the source tree and drop it into input field Array #2
  6. Select Field #2
  7. Click on OK

Example

Array #1 = [{"id":1,"name":"john","genre":"male","age":23},{"id":2,"name":"tom","genre":"male","age":19},{"id":3,"name":"maria","genre":"female","age":23}]
Field #1 = "id"
Array #2 = [{"id":1,"role":"user"},{"id":2,"role":"user"},{"id":3,"role":"admin"}]
Field #2 = "id"

Output = [{"id":1,"name":"john","genre":"male","age":23,"join_fields":{"id":1,"role":"user"}},{"id":2,"name":"tom","genre":"male","age":19,"join_fields":{"id":2,"role":"user"}},{"id":3,"name":"maria","genre":"female","age":23,"join_fields":{"id":3,"role":"admin"}}]