Join List By Key

Hi guys,

I have two lists that have a key in common. I want to do a JOIN (as in a database) with each other. Join list A with list B when both have the key in common.

Does anyone have any idea how to do this?

Hi I tried to implement that:

Search the store for
ROdBp21WuuaTjtTm5xcyHQ

Implementation Details
inputs = {
list1
list2
input2Key
input1Key
};

const mapList2ToList1 = inputs.input1.map(input1Element => ({

  ...input1Element, 

  ...inputs.input2.find(input2Element => input1Element[inputs.input1Key] === input2Element[inputs.input2Key])

}));

const mapRemainingInList2 = inputs.input2

    .filter(input2Element => mapList2ToList1.find(input1Element => input1Element[inputs.input1Key] === input2Element[inputs.input2Key]) === undefined);

return { 

  result: [

    ...mapList2ToList1,

    ...mapRemainingInList2

  ]

};

Hi, this is really interesting. Can I join a data variable list with a page variable list? Is the key selectable from the object properties in the lists?