Share
Report
11I have two outputs from a parse JSON I need to join. I'm having a difficult time because the numbers in set one are not known and will change every run. The numbers in set two will always be exactly 1:1 of set one. I need to "left join" the two so that I end up with something like the final set below. I know how to do it if the number in set one doesn't change... but I'm having a hard time wrapping my mind on how to do this when the "field name" will be different. I thought of a apply to each of the first set with a filter of the second set but I dont know how to address the first item in the set without knowing its "name" so to speak. Please help if you can.
Set 1.
{
"2778101": "29",
"2778111": "23.5",
"2778115": "24"
}
Set 2
{
"2778101": {
"id": 2778101,
"first_name": "John",
"last_name": "Smith",
},
"2778111": {
"id": 2778111,
"first_name": "Jason",
"last_name": "Smith",
},
"2778115": {
"id": 2778115,
"first_name": "Kyle",
"last_name": "Smith",
}
}
"2778101": {
"id": 2778101,
"first_name": "John",
"last_name": "Smith",
},
"2778111": {
"id": 2778111,
"first_name": "Jason",
"last_name": "Smith",
},
"2778115": {
"id": 2778115,
"first_name": "Kyle",
"last_name": "Smith",
}
}
Desired Output
{
"John Smith": "29",
"Jason Smith": "23.5",
"Kyle Smith": "24"
}
Categories:
All responses (
Answers (
