"Assigning an array as a value to an object key when detecting duplicates in a

Question

"Assigning an array as a value to an object key when detecting duplicates in a

Let's assume the table I'm iterating through looks like this:

https://i.stack.imgur.com/HAPrJ.png

I want to convert each unique value in the second column into an object, where one of the keys will hold all values from corresponding rows. Here's what I have so far:

skillMatrix[0]: {val: 2, agents: ['val1', 'val2', 'val3']

However, I've hit a snag and can't progress beyond this point.

    for (i = 0; i < q.length; i++) {
        skillMatrix[i] = {}
    }

$.ajax(getSkills).done(function (res) {

                var sg;

    $(res).find('td:nth-child(3)').each(function(){

                a = $(this).parent().find('td:nth-child(2)').text();
                a = a.split('.');

                if(a[1] == '') {
                first = a[3];
                last = a[2];
                }
                else {
                first = a[2];
                last = a[1];
                }
                reJoin = last + ' ' + first;

                var sg = $(this);
                sg = sg.text().split('_');
                sg = sg[3];

                for (i = 0; i < q.length; i++) {
                    if (q[i] == sg) {
                    skillMatrix[i].group = sg;
                    skillMatrix[i].ag = reJoin;
                    }
                }
    })

})

javascript jquery oop

Answer 1

Answer №1

To start off, the first step is to gather the unique values from each row. This can be achieved by iterating through each row and adding the text of the second column to an array only if it's not already included. The following code snippet demonstrates how this can be implemented:

var arr=[];
    $("tr").each(function(){
      if(!arr.includes($(this).find('td:eq(1)').text())){
        arr.push($(this).find('td:eq(1)').text());
      }
    })

Next, iterate over each of these unique values and select the td element that contains the corresponding value from the arr array using:

$("tr td:nth-child(2):contains("+arr[i]+")")

.

Then, for each selected element, access its parent element and find the first column that includes the agent information:

$(this).parent().find("td:eq(0)").text()

.

Combine all these steps into a JavaScript object, resulting in the following example:

var arr=[];

$("tr").each(function(){
  if(!arr.includes($(this).find('td:eq(1)').text())){
    arr.push($(this).find('td:eq(1)').text());
  }
})
  var obj={};
for(var i=0;i<arr.length;i++)
{
var agents=[];
$("tr td:nth-child(2):contains("+arr[i]+")").each(function(){

agents.push($(this).parent().find("td:eq(0)").text());


});

obj[i]= {val: arr[i], agents:agents};
}

console.log(obj);

td{
border:solid 1px;
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table>
  <tbody>
    <tr>
      <td>value 1</td>
      <td>2</td>
    </tr>
    <tr>
      <td>value 2</td>
      <td>3</td>
    </tr>
    <tr>
      <td>value 3</td>
      <td>2</td>
    </tr>
    <tr>
      <td>value 4</td>
      <td>1</td>
    </tr>
  </tbody>
</table>

Answer 2

To start off, the first step is to gather the unique values from each row. This can be achieved by iterating through each row and adding the text of the second column to an array only if it's not already included. The following code snippet demonstrates how this can be implemented:

var arr=[];
    $("tr").each(function(){
      if(!arr.includes($(this).find('td:eq(1)').text())){
        arr.push($(this).find('td:eq(1)').text());
      }
    })

Next, iterate over each of these unique values and select the td element that contains the corresponding value from the arr array using:

$("tr td:nth-child(2):contains("+arr[i]+")")

.

Then, for each selected element, access its parent element and find the first column that includes the agent information:

$(this).parent().find("td:eq(0)").text()

.

Combine all these steps into a JavaScript object, resulting in the following example:

var arr=[];

$("tr").each(function(){
  if(!arr.includes($(this).find('td:eq(1)').text())){
    arr.push($(this).find('td:eq(1)').text());
  }
})
  var obj={};
for(var i=0;i<arr.length;i++)
{
var agents=[];
$("tr td:nth-child(2):contains("+arr[i]+")").each(function(){

agents.push($(this).parent().find("td:eq(0)").text());


});

obj[i]= {val: arr[i], agents:agents};
}

console.log(obj);

td{
border:solid 1px;
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table>
  <tbody>
    <tr>
      <td>value 1</td>
      <td>2</td>
    </tr>
    <tr>
      <td>value 2</td>
      <td>3</td>
    </tr>
    <tr>
      <td>value 3</td>
      <td>2</td>
    </tr>
    <tr>
      <td>value 4</td>
      <td>1</td>
    </tr>
  </tbody>
</table>

"Assigning an array as a value to an object key when detecting duplicates in a

Answer №1

Similar questions

Is it possible to categorize a JSON object based on its properties and then count the occurrences of each property within

The array filtering functionality is not functioning as intended

The file_get_contents() function encountered an issue as the content type was not specified, leading to it assuming

Error: Attempting to access index '0' of an undefined property in firebase and vuex

Encounter issues with v-for functionality when using Internet Explorer 11

Prompt for confirmation in ASP.NET code-behind with conditions

Automatically scroll to the end of the data retrieved through ajax

What could be causing my unique Angular custom date filter to output nonsensical results?

Error TS2339 encountered in ngx-uploader: There is no property called 'lastModifiedDate' on the type 'File'

Executing a script in the browser console automatically upon clicking a link can be achieved using Python

Removing a parameter from a variable in jQuery and JavaScript

Check the status of the audio source URL using JavaScript

The command '.' is unable to be executed as an internal or external command, executable program, or batch file when using npm start -- -e=stag -c=it

What is the most efficient way to extract a key and its corresponding value from an object containing only one pair?

problem encountered when attempting to fetch a value through ajax

Issues arising from jQuery AJAX request in Chrome extension

Is there a way to modify a specific key value in all embedded objects using Mongoose?

JavaScript in Internet Explorer is showing an error message stating that it is unable to access the property '0' of an undefined or null

Identify and target a particular DIV based on the URL for customization

Processing information received through an ajax.post request