Column from array of arrays if another column match criteria in JavaScript

Question

I have following array of arrays showing employee name, id and department

var employees = [
["John","001","Sales"]
["Mike","002","Sales"]
["Adam","003","Eng"]
["Sam","004","Sales"]
["Emma","005","Eng"]
];

how can I get specific column from this array based on another column. For example, I would like to get ID numbers column for all 'Eng' department where result would be:

["003","005"]

score 1 · Accepted Answer · answered Nov 26 '19 at 13:29

1

At first you need to filter your array and then just get necessary values through map method:

var employees = [
  ["John","001","Sales"],
  ["Mike","002","Sales"],
  ["Adam","003","Eng"],
  ["Sam","004","Sales"],
  ["Emma","005","Eng"]
  ];    

  const result = employees.filter(f=> f.some(s=>s == 'Eng')).map(([a, b, c]) => b);

  console.log(result);

answered Nov 26 '19 at 13:29

StepUp

36,391
15
88
148

Thank you! Works like a charm! – Horzy Nov 26 '19 at 16:39
@Horzy I am glad to help you!:) – StepUp Nov 26 '19 at 17:43

score 0 · Answer 2 · answered Nov 26 '19 at 13:31

You can use map() on the array to filter through and get the data you want.

var employees = [
    ["John", "001", "Sales"],
    ["Mike", "002", "Sales"],
    ["Adam", "003", "Eng"],
    ["Sam", "004", "Sales"],
    ["Emma", "005", "Eng"]
];

function getColumnFor(data, dept) {
    const output = [];
    data.map(function (item) {
        if (item[2].toLowerCase() === dept.toLowerCase()) {
            output.push(item[1]);
        }
    });
    return output;
}

const result = getColumnFor(employees, "Eng");
console.log(result);

score 0 · Answer 3 · answered Nov 26 '19 at 13:31

If your array in formate, you can do as below

var employees = [
["John","001","Sales"],
["Mike","002","Sales"],
["Adam","003","Eng"],
["Sam","004","Sales"],
["Emma","005","Eng"]
];


var codes = [];
for(var k in employees){
 if(employees[k][2] == 'Eng'){
    codes.push(employees[k][1]);
 }
  
}

console.log(codes);

Column from array of arrays if another column match criteria in JavaScript

3 Answers3