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"}}]