Add json key from array

Question

I'm trying to add elements to a JSON from items of an array, but I'm struggling to pass the elements to the JSON.

here is my code:

var j = {
    "Root": {
        "a": "1800,1200,3100",
        "b": "1500,1999,2001",
        "c": "40,60,50",
        "d": "this is not needed",
        "e": "nor this one"
    }
};
var root = j.Root,
    l = root.a.split(",").length,
    hash = ["a", "b", "c"];


for (var i = 0; i < l; i++) {
    for (var x = 0; x < hash.length; x++) {
        root['row_' + i] = {
            "a": root.a.split(",")[i],
            "b": root.b.split(",")[i],
            "c": root.c.split(",")[i] // I don't want to do this for each key
        };
    }
}



for (var x = 0; x < hash.length; x++) {
    delete root[hash[x]];
}

console.log(JSON.stringify(j));

My code is working, but I'm looking for a proper way to use the elements of my array because I will have more than a,b,c

PS: not all key will be used

There's no such thing as a "JSON Object" What you have is a JavaScript object. — phuzi
– phuzi, Commented Apr 9, 2018 at 10:56
@AnkitAgarwal the array is the hash, my expected output is correct, but I don't want to explicitly name every element in my loop — Jonathan
– Jonathan, Commented Apr 9, 2018 at 10:58

Ankit Agarwal · Accepted Answer · 2018-04-09 11:27:51Z

1

You can use Object.keys which will give you the keys for the object in hash variable. Then it will be dynamic for your code to detect all the possible keys in Root object:

var j = {
    "Root": {
        "a": "1800,1200,3100",
        "b": "1500,1999,2001",
        "c": "40,60,50",
        "d": "152,199,21",
        "e": "15,19,200"
    }
};
var root = j.Root,
    l = root.a.split(",").length,
    hash = ["a", "b", "c"];


for (var i = 0; i < l; i++) {
    var obj = {};
    for (var x = 0; x < hash.length; x++) {
        obj[hash[x]] = root[hash[x]].split(",")[i];
    }
    root['row_' + i] = obj;
}


for (var x = 0; x < hash.length; x++) {
    delete root[hash[x]];
}
console.log(root);
console.log(JSON.stringify(j));

edited Apr 9, 2018 at 11:27

answered Apr 9, 2018 at 10:59

Ankit Agarwal

30.8k5 gold badges41 silver badges63 bronze badges

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

9 Comments

Jonathan Over a year ago

the problem is I will not use all the key of the object, I will only use the ones that can be split

Ankit Agarwal Over a year ago

What do you mean by that @Jonathan

Ankit Agarwal Over a year ago

@Jonathan check now

Ankit Agarwal Over a year ago

@Andreas The keys are not specific. You see that there is a hash variable that says that only the variables in hash needs to be changed for the keys

Ankit Agarwal Over a year ago

@Andreas check what the OP asks. He says he only want to have hash variables and not all the keys. So, there might be the case that hash variable is known with the name of the keys.

|

Nina Scholz · Accepted Answer · 2018-04-09 11:43:28Z

1

You could iterate the keys and build new properties.

var object = { Root: { a: "1800,1200,3100", b: "1500,1999,2001", c: "40,60,50", d: "this is not needed", e: "nor this one" } },
    reference = object.Root;

Object
    .keys(reference)
    .forEach(k => {
        var values = reference[k].split(',');
        if (values.length === 1) {
            return;
        }
        values.forEach((v, i) => {
            reference['row_' + i] = reference['row_' + i] || {};
            reference['row_' + i][k] = v;
        });        
        delete reference[k];
    });

console.log(object);

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

edited Apr 9, 2018 at 11:43

answered Apr 9, 2018 at 11:07

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

Narendra Jadhav · Accepted Answer · 2018-04-09 11:58:13Z

1

You can get your required result using the following methods

DEMO

const root = {
    "Root": {
      "a": "1800,1200,3100",
      "b": "1500,1999,2001",
      "c": "40,60,50",
      "d": "this is not needed",
      "e": "nor this one"
    }
  },
  hash = ["a", "b", "c"],
  keys = Object.keys(root.Root);


let result = Object.values(root.Root).reduce((obj, value, index) => {
  if (value.match(',')) {
    value = value.split(',');
    obj[`row_${index}`] = hash.reduce((object, key, index) => {
      object[key] = value[index];
      return object;
    }, {});
  } else {
    obj[keys[index]] = value;
  }
  return obj;
}, {})

console.log(result);

edited Apr 9, 2018 at 11:58

answered Apr 9, 2018 at 11:39

Narendra Jadhav

10.3k15 gold badges35 silver badges45 bronze badges

2 Comments

Jonathan Over a year ago

what happened to d & e ?

Narendra Jadhav Over a year ago

@Jonathan I have included d & e as well. Please check

Collectives™ on Stack Overflow

Add json key from array

3 Answers 3

9 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related