GoogleScript - map an array of array from elements of another array

Question

I'm working on a GAS that takes a dataRange from Sheet (columns + rows) only to return a selection of columns. The selection of columns is done from elements in an array.

let dtARange = [["Number", "Created", "X", "V", "E", "Name", "Section", "School", "Organisation", "Teacher1","Teacher2","Hour1","Hour2"],
["3","September","x","x","","ThisClass","ThisSection","MySchool","MyOrganisation","Mr John","Mr Paul","Noon","Evening"],
["4","May","","x","","ThisOtherClass","ThisOtherSection","MyOtherSchool","MyOtherOrganisation","Mr Favreau","Mr Vinx","Noon","Evening"]]; 

let [headers,...data] = dtARange;

//I have headers and data. Now I have a selection that comes in an array

let mySelection = ["Number","Name","School","Teacher1"]; // for example

What I need to be able to do is to retrieve what's in data from these headers in mySelection. I don't need the headers really, but to build a new array that has the data from all the columns I pick.

I'm trying several different things but it doesn't really work out so far (in my real sheet, I have hundreds of rows of course).

Thank you if you can help,

Tanaike · Accepted Answer · 2022-01-14 13:22:10Z

1

In your situation, how about the following sample script?

Sample script:

let dtARange = [["Number", "Created", "X", "V", "E", "Name", "Section", "School", "Organisation", "Teacher1", "Teacher2", "Hour1", "Hour2"],
["3", "September", "x", "x", "", "ThisClass", "ThisSection", "MySchool", "MyOrganisation", "Mr John", "Mr Paul", "Noon", "Evening"],
["4", "May", "", "x", "", "ThisOtherClass", "ThisOtherSection", "MyOtherSchool", "MyOtherOrganisation", "Mr Favreau", "Mr Vinx", "Noon", "Evening"]];
let [headers, ...data] = dtARange;
let mySelection = ["Number", "Name", "School", "Teacher1"]; // for example

// I added below script.
const indexes = mySelection.map(e => headers.indexOf(e));
const res = data.map(r => indexes.map(c => r[c]));
console.log(res)

Reference:

map()

answered Jan 14, 2022 at 13:22

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user13746257 Over a year ago

Thank you, very well solved !

Tanaike Over a year ago

@Cedric Thank you for replying. I'm glad your issue was resolved.

Collectives™ on Stack Overflow

GoogleScript - map an array of array from elements of another array

1 Answer 1

Sample script:

Reference:

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Sample script:

Reference:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related