Hey everyone,
I’m hitting a roadblock in Make while trying to merge two arrays into a single combined array. Both arrays have the same number of objects (24 each), and my goal is to combine corresponding elements (e.g., item 0 from Array A with item 0 from Array B, item 1 from Array A with item 1 from Array B, etc.).
I need to do it cause there is no other way for me to add them to a google sheets columns on the same row without triggering a nested loop from 2 iterators. (at least I guess there is no other way)
My Goal was to use map() and merge() to get a combinedArray where each element looks like: { “range”: “…”, “price”: “…”, “collectTime”: “…”, “stationCode”: “…”, “dataItemMap”: {…} }
My main map() formula, which looks something like this, consistently produces an array of 24 empty objects:
Some of the items of the data array are empty, but not all.
map(5.items; " item"; “index”; merge(“item”; get(3.data:data; “index”)))
From the sidebar I pick the data array data:data, somewhere I saw that it should be data.data, but idk how to get there.
Could someone please help me out with some insight?
