Skip to content

Add the example of @customfunction #2

@oshliaer

Description

@oshliaer

https://docs.google.com/spreadsheets/d/1DVviAUj5FbEEOMDgPg0GSY8FGdDeynF22rilsumRIHo/edit?usp=sharing

var alasql = AlaSQLGS.load();
alasql.options.modifier = 'MATRIX';
alasql.aggr.GROUP_CONCAT = function(v,s){
  if(typeof v == "undefined") return s;
  if(typeof s == "undefined") return v; else return [s,v].join(', ');
};

function ALASQL(query, data) {
  var res = alasql(query, [data]);
  return res;
}

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions