Merging elements of an array

Question

Merging elements of an array

There is a single array that holds appointmentID (first value) and supperBillID (second value) separated by a comma. The AppointmentID will always be unique, but the superBillID can be repeated in consecutive positions. The goal is to create an array that groups all appointmentID values with the same billingID, separated by commas.

I have attempted to write the following code, but it is not producing the desired output:

var fg = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];
var tab = [];
var gbl = 0;

for (var i = 0; i < fg.length; i++, gbl++) {
    var vb = fg[gbl].split(',')[1]; // Will use try catch here
    var mainAr = fg[gbl].split(',')[0];

    for (var j = i + 1; j < fg.length; j++) {
        if (vb == fg[j].split(',')[1]) {
            mainAr = mainAr + ',' + fg[j].split(',')[0];
            gbl++;
        }
        else {
            break;
        }
        tab.push(mainAr, vb);
    }
}

Sample Input:

var input = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];

Expected Output:

output = ['10000021,10000023',23]
         ['10000023',24]
         ['10000024,10000025,10000026',25]
         ['10000027',26]
         ['10000028',27]

javascript arrays loops split append

Answer 1

Answer №1

If you're looking to organize the appointmentID values and avoid duplicates using billingID as the key, you can start by utilizing Array.reduce() to group them into a Set.

Then, you can further refine the structure using Array.map() on the object generated, depending on the desired output format. You can choose between an array of arrays or an array of strings resembling the input style.

var input = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];

let output = input.reduce((acc, str) =>
{
    const [appointmentID, billingID] = str.split(",");
    acc[billingID] = acc[billingID] || new Set();
    acc[billingID].add(appointmentID);
    return acc;
}, {});

// Transform to array of arrays:
let out1 = Object.entries(output).map(([k, v]) => [[...v].join(","), +k]);
console.log("Array of arrays", out1);

// Transform to array of strings:
let out2 = Object.entries(output).map(([k, v]) => [...v, k].join(","));
console.log("Array of strings", out2);

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

Another approach, considering unique AppointmentID and potential repetition of superBillID in consecutive positions, could be:

var input = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];
let output = [];

for (let i = 0; i < input.length; i++)
{
    const [appointmentID, billingID] = input[i].split(",");
    const len = output.length - 1;

    if (output[len] && output[len][1] === +billingID)
        output[len][0] += "," + appointmentID;
    else
        output.push([appointmentID, +billingID]);
}

console.log(output);

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

Answer 2

If you're looking to organize the appointmentID values and avoid duplicates using billingID as the key, you can start by utilizing Array.reduce() to group them into a Set.

Then, you can further refine the structure using Array.map() on the object generated, depending on the desired output format. You can choose between an array of arrays or an array of strings resembling the input style.

var input = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];

let output = input.reduce((acc, str) =>
{
    const [appointmentID, billingID] = str.split(",");
    acc[billingID] = acc[billingID] || new Set();
    acc[billingID].add(appointmentID);
    return acc;
}, {});

// Transform to array of arrays:
let out1 = Object.entries(output).map(([k, v]) => [[...v].join(","), +k]);
console.log("Array of arrays", out1);

// Transform to array of strings:
let out2 = Object.entries(output).map(([k, v]) => [...v, k].join(","));
console.log("Array of strings", out2);

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

Another approach, considering unique AppointmentID and potential repetition of superBillID in consecutive positions, could be:

var input = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];
let output = [];

for (let i = 0; i < input.length; i++)
{
    const [appointmentID, billingID] = input[i].split(",");
    const len = output.length - 1;

    if (output[len] && output[len][1] === +billingID)
        output[len][0] += "," + appointmentID;
    else
        output.push([appointmentID, +billingID]);
}

console.log(output);

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

Answer 3

Answer №2

To condense the array, you can utilize the reduce method by treating each supperBillID as a key in the accumulator. Update the 0 index if the supperBillID already exists, otherwise add the key to the accumulator and assign it to an array. Extract the values as an array with the help of Object.values()

var fg = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];

const merged = fg.reduce((acc, o) => {
  const [appId, billId] = o.split(',');
  if (acc[billId])
    acc[billId][0] += `,${appId}`;
  else
    acc[billId] = [appId, billId]
  return acc;
}, {})

const output = Object.values(merged);

console.log(output)

Answer 4

To condense the array, you can utilize the reduce method by treating each supperBillID as a key in the accumulator. Update the 0 index if the supperBillID already exists, otherwise add the key to the accumulator and assign it to an array. Extract the values as an array with the help of Object.values()

var fg = ['10000021,23', '10000022,23', '10000023,24', '10000024,25', '10000025,25', '10000026,25', '10000027,26', '10000028,27'];

const merged = fg.reduce((acc, o) => {
  const [appId, billId] = o.split(',');
  if (acc[billId])
    acc[billId][0] += `,${appId}`;
  else
    acc[billId] = [appId, billId]
  return acc;
}, {})

const output = Object.values(merged);

console.log(output)

Answer 5

Answer №3

Begin by transforming the array into a more manageable array of objects, then proceed to condense the array based on the specified condition

const input = [
  "10000021,23",
  "10000022,23",
  "10000023,24",
  "10000024,25",
  "10000025,25",
  "10000026,25",
  "10000027,26",
  "10000028,27"
];

const dataset = input.map(item => {
  const nodes = item.split(",");

  return {
    appointmentid: nodes[0],
    superbillid: nodes[1]
  };
});

const output = dataset.reduce((accumulator, current) => {
  const item = accumulator.find(
    element => element[element.length - 1] === current.superbillid
  );

  if (item !== undefined) {
    item.unshift(current.appointmentid);
  } else {
    accumulator.push([current.appointmentid, current.superbillid]);
  }

  return accumulator;
}, []);

console.log(output);

If you want to obtain an array of strings, you can achieve this by using the map function on each item in the array like so

const recipient = output.map(item => item.join(',')));

This operation will result in

[
  "10000022,10000021,23",
  "10000023,24",
  "10000026,10000025,10000024,25",
  "10000027,26",
  "10000028,27"
]

Answer 6

Begin by transforming the array into a more manageable array of objects, then proceed to condense the array based on the specified condition

const input = [
  "10000021,23",
  "10000022,23",
  "10000023,24",
  "10000024,25",
  "10000025,25",
  "10000026,25",
  "10000027,26",
  "10000028,27"
];

const dataset = input.map(item => {
  const nodes = item.split(",");

  return {
    appointmentid: nodes[0],
    superbillid: nodes[1]
  };
});

const output = dataset.reduce((accumulator, current) => {
  const item = accumulator.find(
    element => element[element.length - 1] === current.superbillid
  );

  if (item !== undefined) {
    item.unshift(current.appointmentid);
  } else {
    accumulator.push([current.appointmentid, current.superbillid]);
  }

  return accumulator;
}, []);

console.log(output);

If you want to obtain an array of strings, you can achieve this by using the map function on each item in the array like so

const recipient = output.map(item => item.join(',')));

This operation will result in

[
  "10000022,10000021,23",
  "10000023,24",
  "10000026,10000025,10000024,25",
  "10000027,26",
  "10000028,27"
]

Merging elements of an array

Answer №1

Answer №2

Answer №3

Similar questions

Making if-else statements easier

What is the best way to extract clean text from HTML using JavaScript?

Enhance state using the values from radio buttons in a React application

Retrieving Data from Outside Source using AngularJS

What is the best way to outline the specifications for a component?

Finding the Perfect Placement for an Element in Relation to its Companion

Is the Webpack vendors JS bundle in Vue CLI containing unlisted code that is not in the dependencies or package-lock.json file?

Engaging JavaScript Navigation

Issue with custom function not being triggered by datepicker onSelect in Internet Explorer with JQuery

Acquire feedback from PHP using SweetAlert notifications

Double the fun: JavaScript array appears twice!

I am looking to download a file from a server and showcase it in a browser using React.js. The file will be received as a response from the

PHP - retrieve a one-dimensional array from a key-value paired array

Can you explain the concept of asynchronous in the context of Ajax?

The back button stops working following the execution of window.location.replace(href);

Tips on running jQuery scripts when a div changes its display style from none to block?

Alignment of Material-UI dialogue buttons on the left side

Analog Clock Time Adjustment Bubble Deviation Dilemma

Cookies in Node.js Express are not being incorporated

Utilize the inherited background color for a linear-gradient effect