I have a collection that has a long list of variables that look like this: child_name1 child_id1 child_birthdate1 child_name2 child_id2 child_birthdate2
… child_name12 child_id12 child_birthdate12
I want each “triplet” to go into a new Google Sheets row (one row per child).
I tried using an Iterator, but that put each value into a new row, but I need each 3 values (and not all values are of this pattern, there are others that are not relevant).
Hi @Crumbs , I used this kind of scenario composed of a repeater and 2 filters before adding a Sheet Row. Can also be used with Iterator, have to replace ‘i’ with ‘Bundle Position’. It does consume some operations though, there should be a better solution to “slice array every x element”, but afaik there’s no native function. Here what I’m doing is basically slicing elements of index i to i+4 if i%4=0 (repeat every 4 elements, in your case 3) and getting all elements from this slice with get(array,1) …2 …3 …4. Keep in mind that array indexes start from 1 in Make.
Thanks for the suggestion @kudracha ! It’s much appreciated. I ended up solving it by using a Repeater module (12 repeats), and then using a switch case on the index of the repetition like this: