Is there any way in Underscorejs - IndexBy for multiple variables?

Question

I have a JSON object as below upComingArray":

[
        {
            "companyAlias": "ABC",
            "refNo": "ABC0001",
            "Date": "12/09/2018",            
            "Sub": "ABC Subj" ...
        },
        {
            "companyAlias": "ABC",
            "refNo": "ABC0002",
            "Date": "12/09/2018", 
            "Sub": "ABC Subj1" ...
        },
        {
            "companyAlias": "ABC",
            "refNo": "ABC0003",
            "Date": "12/09/2018", 
            "Sub": "ABC Subj3"...
        },
        {
            "companyAlias": "BCD",
            "refNo": "BCD0001",
            "Date": "14/09/2018", 
            "Sub": "BCD Subj"...
        },
       {
            "companyAlias": "BCD",
            "refNo": "BCD0002",
            "Date": "14/09/2018", 
            "Sub": "BCD Subj2"...
        },...
]

I would like to convert it to the below format for ease processing (basically group by companyAlias and Date)

upComingArray":

[
        {
            "companyAlias": "ABC",            
            "Date": "12/09/2018" 
             [ {   
                "refNo": "ABC0001"
               "Sub": "ABC Subj"
               },           
               {
                "refNo": "ABC0002",            
                "Sub": "ABC Subj1"
               },
               {            
               "refNo": "ABC0003",            
                "Sub": "ABC Subj3"
            }]
         },
        {
            "companyAlias": "BCD",
            "Date": "14/09/2018"
             [
             {
             "refNo": "BCD0001",
             "Sub": "BCD Subj"
            },
           {

            "refNo": "BCD0002",            
            "Sub": "BCD Subj2"
        }]
},...
]

If anyone have idea, Please let me know...

Thanks in Advance

Answer 1

The below code is working.

var inputArray = [
    {
        "companyAlias": "ABC",
        "refNo": "ABC0001",
        "Date": "12/09/2018",            
        "Sub": "ABC Subj" ...
    },
    {
        "companyAlias": "ABC",
        "refNo": "ABC0002",
        "Date": "12/09/2018", 
        "Sub": "ABC Subj1" ...
    },
    {
        "companyAlias": "ABC",
        "refNo": "ABC0003",
        "Date": "12/09/2018", 
        "Sub": "ABC Subj3"...
    },
    {
        "companyAlias": "BCD",
        "refNo": "BCD0001",
        "Date": "14/09/2018", 
        "Sub": "BCD Subj"...
    },
   {
        "companyAlias": "BCD",
        "refNo": "BCD0002",
        "Date": "14/09/2018", 
        "Sub": "BCD Subj2"...
    }
]

var resultArray = groupByMultiple(inputArray ,function(item)
        {
        return [item.companyAlias, item.Date];
});

function groupByMultiple( array , f )
        {
          var groups = {};
          array.forEach( function( o )
          {
            var group = JSON.stringify( f(o) );
            groups[group] = groups[group] || [];
            groups[group].push( o );  
          });
          return Object.keys(groups).map( function( group )
          {
            return groups[group]; 
          })
        }

Answer 2

use below code snippet for required results

1. GroupBy companyAlias
2. use _.map

  let arr = [
        {
            "companyAlias": "ABC",
            "refNo": "ABC0001",
            "Date": "12/09/2018",
            "Sub": "ABC Subj"
        },
        {
            "companyAlias": "ABC",
            "refNo": "ABC0002",
            "Date": "12/09/2018",
            "Sub": "ABC Subj1"
        },
        {
            "companyAlias": "ABC",
            "refNo": "ABC0003",
            "Date": "12/09/2018",
            "Sub": "ABC Subj3"
        },
        {
            "companyAlias": "BCD",
            "refNo": "BCD0001",
            "Date": "14/09/2018",
            "Sub": "BCD Subj"
        },
       {
            "companyAlias": "BCD",
            "refNo": "BCD0002",
            "Date": "14/09/2018",
            "Sub": "BCD Subj2"
        }
];


let arry1 = _.groupBy(arr, 'companyAlias' );

let finalArr = _.map(arry1, function(value, key){
  return {
    'companyAlias': key ,
    'Date': value[0].Date ,
    arr: _.map(value, function(arry){ return { 'refNo': arry.refNo, 'Sub': arry.Sub } })
  }
});

console.log('Final Array : ', finalArr);

<script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.9.1/underscore-min.js"></script>