Can you please provide an example of how to use the MERGE node, specifically with the “Merge by Key” option?
I have two sets of data below as an example. How do I setup the merge by key node to match data[].interviewers[].id from Input 1 (e.g. 111222333) with the fields.eid in Input 2 and combine the data wherever there is a match?
Thanks!
Input 1 Data:
{
“data”: [
{
“pointer”: “12345”,
“panel”: “234234”,
“subject”: “Blah Blah”,
“note”: “”,
“interviewers”: [
{
“id”: “111222333”,
“name”: “Bobby Johnson”,
“email”: “[email protected]”
}
],
“timezone”: “America/Los_Angeles”,
},
{
“pointer”: “98754”,
“panel”: “3243234”,
“subject”: “Yadda Yadda”,
“note”: “”,
“interviewers”: [
{
“id”: “444555666”,
“name”: “Billy Johnson”,
“email”: “[email protected]”
}
],
“timezone”: “America/Los_Angeles”,
},
],
“hasNext”: false
}
Input 2 Data:
[
{
“name”: “test”,
“fields”: {
“FirstName”: “Bobby”,
“LastName”: “Johnson”,
“JobTitleDescription”: “Recruiter”,
“HomeDepartmentDescription”: “Recruiting Team”,
“Photo”: [
{
“x”: “attPuc6gAIHUOHjsY”,
“url”: “http://urlto.com/BobbyPhoto.jpg”,
“filename”: “photo.jpg”,
“size”: 28956,
“type”: “image/jpeg”
}
],
“eid”: “111222333”
},
“createdTime”: “2019-09-23T04:06:48.000Z”
},
{
“name”: “test2”,
“fields”: {
“FirstName”: “Billy”,
“LastName”: “Johnson”,
“JobTitleDescription”: “CEO”,
“HomeDepartmentDescription”: “Boss Team”,
“Photo”: [
{
“x”: “attPuc6gAIHUOHjsY”,
“url”: “http://urlto.com/BillyPhoto.jpg”,
“filename”: “photo.jpg”,
“size”: 28956,
“type”: “image/jpeg”
}
],
“eid”: “444555666”
},
“createdTime”: “2019-09-23T04:06:48.000Z”
}
,
{
“name”: “test3”,
“fields”: {
“FirstName”: “Susan”,
“LastName”: “Smith”,
“JobTitleDescription”: “CFO”,
“HomeDepartmentDescription”: “Boss Team”,
“Photo”: [
{
“x”: “attPuc6gAIHUOHjsY”,
“url”: “http://urlto.com/SusanPhoto.jpg”,
“filename”: “photo.jpg”,
“size”: 28956,
“type”: “image/jpeg”
}
],
“eid”: “777888999”
},
“createdTime”: “2019-09-23T04:06:48.000Z”
}
]
