# How to split object data realtime database?

**URL:** <https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468>\
**Category:** Dashboard\
**Created:** [14 December 2020 09:19 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468 "2020-12-14T09:19:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [14 December 2020 11:32 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468/2 "2020-12-14T11:32:34Z")

</div>

You need to change the format of your data to match the expected format of the ui\_table.

the help shows you an example...

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/a/2ae407dcc4c549c711a5b56c02c1d288ca71b2ba.png)

You can achieve this in the built in nodes  
e.g. a function node or possibly a change node (using JSONata) or a combination of split --\> join nodes

---

_[View the full topic](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468)._