JQuery to create Download Link

Simple way to download file without navigating.

function downloadFile(filePath){ var link=document.createElement('a'); link.href = filePath; link.download = filePath.substr(filePath.lastIndexOf('/') + 1); link.click(); } downloadFile('filepath/myfile.xlsx');

Convert CSV data to JSON

CSV Data

Output as JSON

JSON Group by count, output to key value pair json result

Following is the JSON and need to manipulate it in format to groupBy.

var rows = [ { 'createdDate': '3/11/2016', 'createdBy': 'Bob' }, { 'createdDate': '3/12/2016', 'createdBy': 'Megan' }, { 'createdDate': '3/12/2016', 'createdBy': 'Bob' }, { 'createdDate': '3/13/2016', 'createdBy': 'Sam' }, { 'createdDate': '3/11/2016', 'createdBy': 'Bob' }, ]; var occurences = rows.reduce(function (r, row) { r[row.createdBy] = ++r[row.createdBy] || 1; return r; }, {}); var result = Object.keys(occurences).map(function (key) { return { key: key, value: occurences[key] }; }); console.log(result);