# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![marwinwijaya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marwinwijaya/32/23923_2.png) [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)\
**Post date:** [14 December 2020 09:19 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468/1 "2020-12-14T09:19:32Z")

</div>

I have a data object in the real-time database. I want to retrieve the object's contents, namely the pump and timestamp, and display the data in a table. How do I do it? What nodes should I install? thank you

 ![Database](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/f/ef69d7c2b931cf075c6e8941af1a945b826612c1.png) ![Node](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/2/12ac32d58d51b9a69442560b91dcf476e6220286.png) ![Split](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/c/2c2ccf1d757977fd05abeb0e11609f8af189e841.png)

---

<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

---

<div class="post-metadata">

**Author:** ![marwinwijaya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marwinwijaya/32/23923_2.png) [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)\
**Post date:** [14 December 2020 13:15 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468/3 "2020-12-14T13:15:06Z")

</div>

Thank you very much for helping, bu I still don't understand how to separate object id (MFI \*\*\*\*\*\*\*\*\*), and there is a constraint where I can't change the data format in firebase

---

<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 14:38 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468/4 "2020-12-14T14:38:40Z")

</div>

> [@marwinwijaya](#):
>
> I still don't understand how to separate object id (MFI \*\*\*\*\*\*\*\*\*), and there is a constraint where I can't change the data format in firebase

You dont need to change the format of your database. You use Javascript (in a function) or JSONata or a combination of split and join nodes. Did you try any of these?

post some sample data in a reply by copying the data from the debug

like this...

![kw0scKwk5x](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/0/d0701a0728fae50a4004735eba43ac4a6a193729.gif)

then post it in a reply

`````  
`paste the copied data between backticks like this`  
`````

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [13 January 2021 14:38 UTC](https://discourse.nodered.org/t/how-to-split-object-data-realtime-database/37468/5 "2021-01-13T14:38:48Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.