json sql based map
by bilbobaggins
JavaScript
var colset=[{"xaxis":"April "},{"xaxis":"August "},{"xaxis":"December "},{"xaxis":"February "},{"xaxis":"January "},{"xaxis":"March "},{"xaxis":"November "},{"xaxis":"September"}]
colset=colset.map(function(doctor) {
return "\"" + doctor.xaxis.replace(/\ /g, "") + "\""
})
var subtotal="("+colset.join('+')+") as subtotal"
var selectclause="yaxis,"+colset.join(',')
console.log(selectclause+","+subtotal)