# Join: make a complete array

**URL:** <https://discourse.nodered.org/t/join-make-a-complete-array/192>\
**Category:** General\
**Created:** [15 May 2018 20:53 UTC](https://discourse.nodered.org/t/join-make-a-complete-array/192 "2018-05-15T20:53:55Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [16 May 2018 21:41 UTC](https://discourse.nodered.org/t/join-make-a-complete-array/192/7 "2018-05-16T21:41:11Z")

</div>

OK, it would be better (imho) to use the join node in manual mode to create a key/value object using msg.topic as the key (and set different topics for each sensor) and set it to send after two inputs and then on any change… that will then produce a message whenever either sensor sends an input, containing the most recent two values in two properties referenced by their topics. eg {temperature: 25, lux:50}

Then construct your query to save to the database using those two properties - for example in the manner recently posted in another thread - [MsgPayload into a query on nodered-sqlite](https://discourse.nodered.org/t/msgpayload-into-a-query-on-nodered-sqlite/142) (though other methods are perfectly valid)

---

_[View the full topic](https://discourse.nodered.org/t/join-make-a-complete-array/192)._