Concat each loop Iteration result in JS

Question

I'm new to JS and developing in general and I'm kind of stuck here.

I want to use a google Sheet as a backend and query it with js/jquery. I queried the sheet correctly and parsed every row of it (achieved with a forEach). The results from column D and B are combined to a string in the end. I got this working, but, of course, I have 5 outputs or so.

So at the moment, every row (5 rows in the sheet) is a single output, concatenated to a string, so the final output is: output(d[i])+string+output(b[j]) , where i and j are the variables from the for loops.

The result in the console is:

(index):103 AccessRequestPending
(index):103 AccesssDenied
(index):103 NotConfirmed
(index):103 toOldVersion
(index):103 UnknownReason

These are the results, when I run the script (only for column D). I can't push the results to an array, because it pushes the result 5 times to the same array. So in the end, there's just one array with [UnknownReason], But I need 1 array(or just the strings, it doesn't matter) with the 5 results concatenated.

I'd like to achieve something like

output(d[i1])+string+output(b[j1]) + output(d[i2])+string+output(b[j2]) + output(d[i3])+string+output(b[j3])

So, I really want to figure it out by myself, but can you tell me how to use every output/result of an iteration and concat it with the iteration before? Or maybe extract each result to it's own variable?

Thanks in advance!

it might help to share a code snippet that currently gives you the results you are seeing. — Stephen Collins
– Stephen Collins, Commented Feb 28, 2018 at 18:53

Lucas Matos · Accepted Answer · 2018-02-28 19:31:19Z

1

I understand that you want to sum all those cells and get the total, if that is your question, you can use JavaScript reduce to concatenate your array in a single result.

Another options can be:

Map
ForEach

Let me know if this solve your question.

Best

answered Feb 28, 2018 at 19:31

Lucas Matos

2,9462 gold badges18 silver badges18 bronze badges

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

Comments

Christopher · Accepted Answer · 2018-03-06 08:16:09Z

0

Sorry, I wasn't available. I combined these 2 arrays into one to map with each other.

let arrayCombined2 = reasonsArray.reduce(function(arr, v, i) {
     return arr.concat(v, arrayUrls[i])}

or for jquery:

let arrayCombined = $.map(reasonsArray, function(k, i) {
return [k, arrayUrls[i]];

answered Mar 6, 2018 at 8:16

Christopher

351 silver badge8 bronze badges

Collectives™ on Stack Overflow

Concat each loop Iteration result in JS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related