I've been searching all morning but most examples of merging was based on only one key, I couldn't find anything on multiple keys.
x = [
{'pid':111, 'sid':6, 'eid':123, 'x_qty':30},
{'pid':222, 'sid':56, 'eid':6212, 'x_qty':2}
]
y = [
{'pid':111, 'sid':6, 'eid':123, 'y_qty':123},
{'pid':333, 'sid':56, 'eid':6212, 'y_qty':112}
]
Values of pid=111, sid=6, eid=123 match in both x and y, then combine as one record. If they don't match, just bring it over as is.
FINAL RESULTS THAT I WANT:
z = [
{'pid': 111, 'sid': 6, 'eid': 123, 'x_qty': 30, 'y_qty': 123},
{'pid': 222, 'sid': 56, 'eid': 6212, 'x_qty': 2},
{'pid': 333, 'sid': 56, 'eid': 6212, 'y_qty': 112}
]
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…