Javascript, how to transform array row to object fields

Question

I need to transform this structure:

[
{"Field1": "value11", "Field2":"value21", "CField1":[{"Id": 1, "Value":"myValue11", "Flag":"Y"}, {"Id": 2, "Value":"myValue12", "Flag":"n"}]},
{"Field1": "value21", "Field2":"value22", "CField1":[{"Id": 1, "Value":"myValue21", "Flag":"Y"}, {"Id": 2, "Value":"myValue22", "Flag":"n"}]}
]

to

[
{"Field1": "value11", "Field2":"value12", "Value1": "myValue11", "Flag1":"Y", "Value2": "myValue12", "Flag2":"n"},
{"Field1": "value21", "Field2":"value21", "Value1": "myValue21", "Flag1":"Y", "Value2": "myValue22", "Flag2":"n"},
]

i found that similar solution:

tab.forEach(function (item) {
  transformedObject[item.key] = transformedObject[item.key] ? `${transformedObject[item.key]}, ${item.value}` : item.value;
});

console.log(transformedObject);

// Access the '2' property
console.log(transformedObject['2']);

but need some help to adapt it to my case

thanks

Nina Scholz · Accepted Answer · 2022-12-12 10:24:57Z

2

You could map the inner array as new objects.

const
    data = [{ Field1: "value11", Field2: "value21", CField1: [{ Id: 1, Value: "myValue11", Flag: "Y" }, { Id: 2, Value: "myValue12", Flag: "n" }] }, { Field1: "value21", Field2: "value22", CField1: [{ Id: 1, Value: "myValue21", Flag: "Y" }, { Id: 2, Value: "myValue22", Flag: "n" }] }],
    result = data.map(({ CField1, ...o }) => Object.assign(
        o,
        ...CField1.map(({ Id, ...q }, i) => Object.fromEntries(Object
            .entries(q)
            .map(([k, v]) => [k + (i + 1), v])
        ))
    ));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Dec 12, 2022 at 10:24

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

gt.guybrush Over a year ago

in perfomance can be better than: ratings.forEach((element, index, array) => { element.CField1.forEach((nuovo) => { element['Value' + nuovo.Id] = nuovo.Value; element['Flag' + nuovo.Id] = nuovo.Flag; }); });

Nina Scholz Over a year ago

you mutate elementand this contains still CField1.

gt.guybrush Over a year ago

correct, i can remove it. not sure about which can be faster

Nina Scholz Over a year ago

how many items do you have?

gt.guybrush Over a year ago

up to some thousands

shaedrich · Accepted Answer · 2022-12-12 10:28:33Z

You can map your data like this:

data = [
{"Field1": "value11", "Field2":"value21", "CField1":[{"Id": 1, "Value":"myValue11", "Flag":"Y"}, {"Id": 2, "Value":"myValue12", "Flag":"n"}]},
{"Field1": "value21", "Field2":"value22", "CField1":[{"Id": 1, "Value":"myValue21", "Flag":"Y"}, {"Id": 2, "Value":"myValue22", "Flag":"n"}]}
]

console.log(data.map(function(value, key) {
  return Object.entries(value).reduce(function(carry, [ key, value ]) {
    if (key !== 'CField1') {
      carry[key] = value
    } else {
      carry = Object.assign(carry, value.reduce(function(innerCarry, value, key) {
         innerCarry[`Flag${value.Id}`] = value.Flag
         innerCarry[`Value${value.Id}`] = value.Value
         return innerCarry;
      }, {}))
    }
    return carry
  }, {})
}))

Collectives™ on Stack Overflow

Javascript, how to transform array row to object fields

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related