After converting two Excel sheets to JSON using an online tool, two separate JSON properties were created for each sheet. The resulting JSON example looks like this:
{
"Product Info": [
{
// Product information details here
},
{
// Another product information details here
}
],
"Company Pricing": [
{
// Company pricing details here
},
{
// Another company pricing details here
}
]
}
Now, the goal is to merge these two properties into a single property that combines all the fields from "Product Info" with the relevant data from "Company Pricing". This can be achieved by performing a left join on "Pricing Reference Name" and "Part Num". While a loop could be used to iterate over each field and push the matching values, there may be a more efficient way to accomplish this without explicitly naming each field, especially considering potential changes in field names over time. Is it possible to achieve this using spread notation (...) to bring over all fields? Any guidance or examples would be greatly appreciated since I haven't found a similar request on Stack Overflow.