# Struggling with Mapping - Multiple Arrays, multiple collections!

**URL:** <https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765>\
**Category:** Beginner Questions\
**Tags:** xero\
**Created:** [January 29, 2025, 10:53am UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765 "2025-01-29T10:53:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![emma](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@emma](https://community.make.com/u/emma)\
**Post date:** [January 29, 2025, 10:53am UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/1 "2025-01-29T10:53:14Z")

</div>

![Screenshot 2025-01-29 at 10.35.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/7/67bb3d0dcfc14ad0f2c64e92f810e2c9f21cecd0.png)

Hi all! Newbie here (and losing my mind!)…

Please see screenshot, this is the output data from getting a bank summary from Xero which shows the headers in one array, 1 bank account and the values in an array called “section” and then the other 3 accounts in an array in “sections”.

All I need from this is the “Closing Balance” value (the fifth value in each collection) from each bank account which I then want to run though a filter (e.g. if closing balance less than 1000) and send a notification.

I’ve tried many things but I can’t seem to actually get this data! Can anyone help me please?

Many thanks!

---

<div class="post-metadata">

**Author:** ![kudracha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/kudracha/32/61210_2.png) [@kudracha](https://community.make.com/u/kudracha)\
**Post date:** [January 29, 2025, 11:10am UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/2 "2025-01-29T11:10:03Z")

</div>

Hi @emma, Can you share the downloaded json output from this ? make sure to text edit the blurred values. Is the structure always repeated in this order ? The solution would be to select

Section [] : Value, but put 5 inside the brackets like this : Section [5] : Value  
And :  
Sections [5] : Value etc.

Mention me if you have questions.

---

<div class="post-metadata">

**Author:** ![emma](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@emma](https://community.make.com/u/emma)\
**Post date:** [January 29, 2025, 12:11pm UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/3 "2025-01-29T12:11:57Z")

</div>

Hi @kudracha , thanks for helping me! This is the output and it appears to always be this order:

[  
{  
“header”: [  
{  
“value”: “Bank Accounts”  
},  
{  
“value”: “Opening Balance”  
},  
{  
“value”: “Cash Received”  
},  
{  
“value”: “Cash Spent”  
},  
{  
“value”: “Closing Balance”  
}  
],  
“section”: [  
{  
“value”: “MHB Current Account”,  
“id”: “XXXX”  
},  
{  
“value”: “XXXX”  
},  
{  
“value”: “XXXX”,  
“id”: “XXXX”  
},  
{  
“value”: “XXXXX”,  
“id”: “XXXX”  
},  
{  
“value”: “XXXX”  
}  
],  
“sections”: [  
[  
{  
“value”: "MHB Business Premium “,  
“id”: “XXXX”  
},  
{  
“value”: “XXXX”  
},  
{  
“value”: “XXXX”,  
“id”: “XXXX”  
},  
{  
“value”: “XXXX”,  
“id”: “XXXXX”  
},  
{  
“value”: “XXXX”  
}  
],  
[  
{  
“value”: “MHB Client Premium”,  
“id”: “XXXXXX”  
},  
{  
“value”: “XXXXX”  
},  
{  
“value”: “XXXX”,  
“id”: “XXXX”  
},  
{  
“value”: “XXXX”,  
“id”: “XXXXX”  
},  
{  
“value”: “XXXX”  
}  
],  
[  
{  
“value”: “MHB Current Account”,  
“id”: “XXXXX”  
},  
{  
“value”: “XXXX”  
},  
{  
“value”: “XXXXX”,  
“id”: “XXXXX”  
},  
{  
“value”: “XXXXX”,  
“id”: “XXXXX”  
},  
{  
“value”: “XXXXX”  
}  
]  
],  
“summary”: [  
{  
“value”: “Total”  
},  
{  
“value”: “XXXXX”  
},  
{  
“value”: “XXXXX”  
},  
{  
“value”: “XXXXX”  
},  
{  
“value”: “XXXXX”  
}  
],  
“ **IMTLENGTH** ”: 1,  
“ **IMTINDEX** ”: 1  
}  
]

I’ve managed to get the value 5 out of section but when I do it for sections (in a different iterator) the array is empty. I need them for all accounts (and there are 3 in “sections”) in one place so I can put them all through a filter. Thanks again

---

<div class="post-metadata">

**Author:** ![kudracha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/kudracha/32/61210_2.png) [@kudracha](https://community.make.com/u/kudracha)\
**Post date:** [January 29, 2025, 1:03pm UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/4 "2025-01-29T13:03:10Z")

</div>

@emma, Here you go. Just import the blueprint in a new scenario and test it out. Your scenario needs an iterator through sections. aggregator is there so we can import sections 1 2 3 in one step - see ‘set variables’ module.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/2/d289b3d6a69b6e6f43227bbcd7ef4d8f39ee3957.png)

[get bank accounts.json](https://community.make.com/uploads/short-url/xE5sXMdYU2YKOrWXE5JsznudCWC.json) (9.8 KB)

---

<div class="post-metadata">

**Author:** ![emma](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@emma](https://community.make.com/u/emma)\
**Post date:** [January 29, 2025, 1:36pm UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/5 "2025-01-29T13:36:59Z")

</div>

@kudracha Thank you so much for this, I’m starting to understand it more now and I can confirm I have all the values I need! Really appreciate your help on this - saved me hours! 😀

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [April 29, 2025, 12:46pm UTC](https://community.make.com/t/struggling-with-mapping-multiple-arrays-multiple-collections/67765/7 "2025-04-29T12:46:44Z")

</div>