# How to create payloads (strings merged/concatenated from array objects) from Excel data?

**URL:** <https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050>\
**Category:** General\
**Tags:** mqtt\
**Created:** [21 September 2022 20:31 UTC](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050 "2022-09-21T20:31:47Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [24 September 2022 17:21 UTC](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050/14 "2022-09-24T17:21:45Z")

</div>

No `$keys()` gives an array of all keys of a object,. Unless only one is returned. To force that to an array, `[$keys()]` would `force a single result to a single array, it would not affect a array with multiple values.

To get values of payload  
`$$.payload.*`

Or if you are in map of an array of objects the context in loop is `$`  
`$$.payload.($.property_name)`

`$.*` would return an array of all values from the object, in a map of an array of objects.

> **[JSONata Documentation · JSONata](https://docs.jsonata.org/overview.html)**
>
> \## Introduction

---

_[View the full topic](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050)._