Looping Javascript Array Objects and Separate Objects With Condition

Question

Let's say I have a variable named data

const data = [
        {loanname: "Mr X", acnumber:  "020000000000001", outstanding: "54000"},
        {loanname: "Mrs Y", acnumber: "020000000000087", outstanding: "87000"},
        {loanname: "Mr Z", acnumber:  "020000000000103", outstanding: "15000"},
        {totalaccount: "3", outstanding: "156000"},
        {loanname: "David", acnumber: "020000000000091", outstanding: "11000"},
        {loanname: "James", acnumber: "020000000001291", outstanding: "4000"},
        {totalaccount: "2", outstanding: "15000"},

    ]

It's an array. I would like to extract data items depending on how many times there are totalaccount. For example, before the first totalaccount, there are three accounts. I would like to extract them.

Also, before the last totalaccount, there are two accounts if we can skip the first totalaccount. I would like to extract information for those two accounts.

To be more precise, how can I convert the array into the following?:

let firstOne = {loanname: "Mr X", acnumber:  "020000000000001", outstanding: "54000"},
    {loanname: "Mrs Y", acnumber: "020000000000087", outstanding: "87000"},
    {loanname: "Mr Z", acnumber:  "020000000000103", outstanding: "15000"},

let secondOne ={loanname: "David", acnumber: "020000000000091", outstanding: "11000"},
    {loanname: "James", acnumber: "020000000001291", outstanding: "4000"},

DecPK · Accepted Answer · 2021-05-26 03:07:37Z

3

You can easily achieve this result using reduce.

First of all, check if there is totalaccount property exists or not. If yes then create a new array in the acc using the push method of Array.prototype If totalaccount property doesn't exists then just push the object in the last array of acc. You need to track the last array element index with current

const data = [
  { loanname: "Mr X", acnumber: "020000000000001", outstanding: "54000" },
  { loanname: "Mrs Y", acnumber: "020000000000087", outstanding: "87000" },
  { loanname: "Mr Z", acnumber: "020000000000103", outstanding: "15000" },
  { totalaccount: "3", outstanding: "156000" },
  { loanname: "David", acnumber: "020000000000091", outstanding: "11000" },
  { loanname: "James", acnumber: "020000000001291", outstanding: "4000" },
  { totalaccount: "2", outstanding: "15000" },
];

let current = 0;
const result = data.reduce((acc, curr) => {
    const { totalaccount } = curr;
    if (totalaccount) {
      acc.push([]);
      ++current;
    } else {
      acc[current].push(curr);
    }
    return acc;
  },
  [[]]
);

const [first, second] = result;
console.log(first);
console.log(second);
console.log(result);

You can also achieve the same result without tracking the current as

const data = [
  { loanname: "Mr X", acnumber: "020000000000001", outstanding: "54000" },
  { loanname: "Mrs Y", acnumber: "020000000000087", outstanding: "87000" },
  { loanname: "Mr Z", acnumber: "020000000000103", outstanding: "15000" },
  { totalaccount: "3", outstanding: "156000" },
  { loanname: "David", acnumber: "020000000000091", outstanding: "11000" },
  { loanname: "James", acnumber: "020000000001291", outstanding: "4000" },
  { totalaccount: "2", outstanding: "15000" },
];

const result = data.reduce(
  (acc, curr) => {
    const { totalaccount } = curr;
    if (totalaccount) {
      acc.push([]);
    } else {
      acc[acc.length - 1].push(curr);
    }
    return acc;
  },
  [[]]
);

console.log(result);

If you want to accumulate into one object and want to create property dynamically

const data = [
  { loanname: "Mr X", acnumber: "020000000000001", outstanding: "54000" },
  { loanname: "Mrs Y", acnumber: "020000000000087", outstanding: "87000" },
  { loanname: "Mr Z", acnumber: "020000000000103", outstanding: "15000" },
  { totalaccount: "3", outstanding: "156000" },
  { loanname: "David", acnumber: "020000000000091", outstanding: "11000" },
  { loanname: "James", acnumber: "020000000001291", outstanding: "4000" },
  { totalaccount: "2", outstanding: "15000" },
];

const result = data.reduce(
  (acc, curr) => {
    const { totalaccount } = curr;
    if (totalaccount) {
      acc.push([]);
    } else {
      acc[acc.length - 1].push(curr);
    }
    return acc;
  },
  [[]]
);

const resultObj = {};
result.forEach((d, i) => {
  if (d.length) {
    resultObj[`collection${i + 1}`] = [...d];
  }
});
console.log(resultObj);

edited May 26, 2021 at 3:07

answered May 26, 2021 at 2:44

DecPK

25.4k6 gold badges32 silver badges46 bronze badges

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

7 Comments

Rashel Over a year ago

It returns all the account numbers. It doesn't split the numbers depending on "totalaccount". In my question I asked if I could convert the array into variables named "firstOne" and "secondOne". Because there are "totalaccount" two times, I would like the array to split into two parts. If there are "totalaccount" 3 times, I would like the array to split into three parts and so on. How can I do that?

DecPK Over a year ago

It will do that for you just check the result array...

RobG Over a year ago

@Rashel—you can't conditionally create arbitrary variables within a loop like firstOne, secondOne, etc. You can either create an array or an object that has properties with the required names and assign the results to them, see Dynamically Creating Variables for Loops.

DecPK Over a year ago

Since result will return an array of array so you can get the data with array indexes.

Rashel Over a year ago

@decpk Your code works for me. I needed the result to split into multiple parts because they are different type of loans and I will need them separate for future calculation.

|

Eric Cheng · Accepted Answer · 2021-05-26 02:50:45Z

0

try this logic (not tested completely, just an idea)

const myArray = [];
for (let i = 0; i < data.length; i++) {
  if (!data[i].totalaccount) continue;
    myArray.push([]);
    for (let x = i - data[i].totalaccount; x <= i - 1; x++) {
      myArray[myArray.length-1].push(data[x]);
    }
}
console.log(myArray);

answered May 26, 2021 at 2:50

Eric Cheng

5271 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

Looping Javascript Array Objects and Separate Objects With Condition

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related