on 06-15-2023 2:45 PM
You should use Get Values (Cells) to get the values from the sheets and Custom Script to get the matching object. I recommend avoiding a loop within a loop.
Example of custom script:
const sheet1 = [
{ ID: 1, Region: "Region A" },
{ ID: 2, Region: "Region B" },
{ ID: 3, Region: "Region C" },
];
const sheet2 = [
{ Region: "Region A", City: "City X" },
{ Region: "Region B", City: "City Y" },
{ Region: "Region C", City: "City Z" },
];
const joinedData = sheet1.map((obj1) => {
const matchingRegion = sheet2.find((obj2) => obj2.Region === obj1.Region);
return { ...obj1, ...matchingRegion };
});
Please vote for my Improvement Request concerning this topic - to have low code/no code activities for data processing - to avoid Custom Script: Improvement Request Details - Customer Influence (sap.com)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
65 | |
8 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.