Transfer Many MQTT Data into ui table

Hi,

I have an issue on combining all MQTT data into a ui table at the same row.
Currently, I have 4 MQTT topics (room/1, room/2, room/3, room/4) to collect the power usage of each room. I wish to upload all data into ui table for data logger.
I found out some forum suggested to use MQTT wildcard type (ex: room/#) to publish the data into ui table, but I have no clue on creating the nodes. Can anybody willing to provide me the sample code?

Thanks.

If you want to get the data for all rooms into a message so you can feed it to the table then you can use a Join node in key/value pairs mode. See this article in the cookbook for an example of how to join messages into one object.

According to the link you provided, I am unable to do it because my inputs are dynamic, not static. If possible, can you provide me some sample code so that I can refer to that?

If you show us the flow you are using, we are more likely to be able to help. We also need the actual format of the Data Input so that we can test the flow.

In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote ```)

``` 
   code goes here 
```

See this post for more details - How to share code or flow json

Show us some sample data and tell us what is dynamic about it.

Here is an example for you, you will need to use your topics and make some adjustment.

[{"id":"e29c9fa46c05635b","type":"inject","z":"65617ffeb779f51c","name":"room1","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room1","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1700,"wires":[["5ac6009e36478cbc"]]},{"id":"5ac6009e36478cbc","type":"mqtt out","z":"65617ffeb779f51c","name":"send test data","topic":"","qos":"","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"e8ba3ef5.22f4a8","x":360,"y":1720,"wires":[]},{"id":"415b655d100e82bd","type":"inject","z":"65617ffeb779f51c","name":"room4","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room4","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1820,"wires":[["5ac6009e36478cbc"]]},{"id":"fd4688d997832f64","type":"inject","z":"65617ffeb779f51c","name":"room3","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room3","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1780,"wires":[["5ac6009e36478cbc"]]},{"id":"fec7458a35197db8","type":"inject","z":"65617ffeb779f51c","name":"room2","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room2","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1740,"wires":[["5ac6009e36478cbc"]]},{"id":"13591952fa1c6b29","type":"mqtt in","z":"65617ffeb779f51c","name":"","topic":"power/+","qos":"2","datatype":"auto-detect","broker":"e8ba3ef5.22f4a8","nl":false,"rap":true,"rh":0,"inputs":0,"x":80,"y":1900,"wires":[["f2b8bed79c2453f1"]]},{"id":"f2b8bed79c2453f1","type":"change","z":"65617ffeb779f51c","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"$split($$.topic, \"/\")[-1]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":260,"y":1900,"wires":[["1f3b08fc723b6579"]]},{"id":"de4b294097d548de","type":"inject","z":"65617ffeb779f51c","name":"reset","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[]","payloadType":"json","x":270,"y":1960,"wires":[["7f14b06c96251e21"]]},{"id":"1f3b08fc723b6579","type":"join","z":"65617ffeb779f51c","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"4","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":410,"y":1900,"wires":[["d3991574ce9840b5"]]},{"id":"d3991574ce9840b5","type":"change","z":"65617ffeb779f51c","name":"","rules":[{"t":"set","p":"payload.date","pt":"msg","to":"$now()","tot":"jsonata"},{"t":"move","p":"payload","pt":"msg","to":"payload.arguments[0][0]","tot":"msg"},{"t":"set","p":"payload.command","pt":"msg","to":"addRow","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":580,"y":1900,"wires":[["7f14b06c96251e21","b22b10d5bda3443c"]]},{"id":"7f14b06c96251e21","type":"ui_table","z":"65617ffeb779f51c","group":"2d4fe667.28f8ba","name":"","order":19,"width":0,"height":0,"columns":[{"field":"date","title":"Date","width":"30%","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room1","title":"Room1","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room2","title":"Room2","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room3","title":"Room3","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room4","title":"Room4","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":650,"y":1940,"wires":[]},{"id":"b22b10d5bda3443c","type":"debug","z":"65617ffeb779f51c","name":"debug 236","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":1800,"wires":[]},{"id":"e8ba3ef5.22f4a8","type":"mqtt-broker","name":"testb","broker":"192.168.1.25","port":"1883","clientid":"node-red-test","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"userProps":"","sessionExpiry":""},{"id":"2d4fe667.28f8ba","type":"ui_group","name":"demo","tab":"1caa8458.b17814","order":2,"disp":true,"width":"12","collapse":false},{"id":"1caa8458.b17814","type":"ui_tab","name":"Demo","icon":"dashboard","order":1,"disabled":false,"hidden":false}]
[
    {
        "id": "eb90474bf03634f2",
        "type": "tab",
        "label": "Flow 4",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "13591952fa1c6b29",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/Value1/#",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "647362d8.d9d214",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 310,
        "y": 420,
        "wires": [
            [
                "f2b8bed79c2453f1"
            ]
        ]
    },
    {
        "id": "f2b8bed79c2453f1",
        "type": "change",
        "z": "eb90474bf03634f2",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "topic",
                "pt": "msg",
                "to": "$split($$.topic, \"/\")[-1]",
                "tot": "jsonata"
            },
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "{\"payload\" : payload}",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 540,
        "y": 420,
        "wires": [
            [
                "1f3b08fc723b6579"
            ]
        ]
    },
    {
        "id": "1f3b08fc723b6579",
        "type": "join",
        "z": "eb90474bf03634f2",
        "name": "",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "2",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 690,
        "y": 420,
        "wires": [
            [
                "d3991574ce9840b5"
            ]
        ]
    },
    {
        "id": "d3991574ce9840b5",
        "type": "change",
        "z": "eb90474bf03634f2",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload.date",
                "pt": "msg",
                "to": "$now()",
                "tot": "jsonata"
            },
            {
                "t": "move",
                "p": "payload",
                "pt": "msg",
                "to": "payload.arguments[0][0]",
                "tot": "msg"
            },
            {
                "t": "set",
                "p": "payload.command",
                "pt": "msg",
                "to": "addRow",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 880,
        "y": 420,
        "wires": [
            [
                "b22b10d5bda3443c",
                "7f14b06c96251e21"
            ]
        ]
    },
    {
        "id": "7f14b06c96251e21",
        "type": "ui_table",
        "z": "eb90474bf03634f2",
        "group": "6f5566a6ee302091",
        "name": "",
        "order": 19,
        "width": 0,
        "height": 0,
        "columns": [
            {
                "field": "date",
                "title": "Date",
                "width": "30%",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room1",
                "title": "Room1",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room2",
                "title": "Room2",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room3",
                "title": "Room3",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room4",
                "title": "Room4",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            }
        ],
        "outputs": 0,
        "cts": false,
        "x": 1070,
        "y": 440,
        "wires": []
    },
    {
        "id": "b22b10d5bda3443c",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 1070,
        "y": 360,
        "wires": []
    },
    {
        "id": "68ea734e80329471",
        "type": "inject",
        "z": "eb90474bf03634f2",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "8",
        "crontab": "",
        "once": true,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 310,
        "y": 200,
        "wires": [
            [
                "d2eecff14d47bd5b"
            ]
        ]
    },
    {
        "id": "d2eecff14d47bd5b",
        "type": "mqtt out",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/Value1/1",
        "qos": "",
        "retain": "",
        "respTopic": "",
        "contentType": "",
        "userProps": "",
        "correl": "",
        "expiry": "",
        "broker": "647362d8.d9d214",
        "x": 500,
        "y": 200,
        "wires": []
    },
    {
        "id": "b6f0791bbd96f496",
        "type": "mqtt out",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/Value1/2",
        "qos": "",
        "retain": "",
        "respTopic": "",
        "contentType": "",
        "userProps": "",
        "correl": "",
        "expiry": "",
        "broker": "647362d8.d9d214",
        "x": 500,
        "y": 280,
        "wires": []
    },
    {
        "id": "cc520ce65fbe2b6a",
        "type": "inject",
        "z": "eb90474bf03634f2",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "8",
        "crontab": "",
        "once": true,
        "onceDelay": "0.5",
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 310,
        "y": 280,
        "wires": [
            [
                "b6f0791bbd96f496"
            ]
        ]
    },
    {
        "id": "647362d8.d9d214",
        "type": "mqtt-broker",
        "name": "",
        "broker": "localhost",
        "port": "1883",
        "clientid": "",
        "usetls": false,
        "compatmode": false,
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "willTopic": "",
        "willQos": "0",
        "willPayload": ""
    },
    {
        "id": "6f5566a6ee302091",
        "type": "ui_group",
        "name": "Group 1",
        "tab": "d6eb2d1eb564a3bc",
        "order": 1,
        "disp": true,
        "width": 6
    },
    {
        "id": "d6eb2d1eb564a3bc",
        "type": "ui_tab",
        "name": "Flow4",
        "icon": "dashboard",
        "order": 18,
        "disabled": false,
        "hidden": false
    }
]

I tried to use timestamp to generate new data every 8 seconds and the data I want to show inside the ui table is timestamp, so as to show my input data is dynamic data.
Then, I want to input the data to ui table by using MQTT wildcard type.
The output I want is the data is like a data logger, whenever the system is running, the value from each MQTT topic will be write into the ui table, as shown in the link: How to make a dynamic Table for MQTT in data - #3 by DemalCal96

[
    {
        "id": "eb90474bf03634f2",
        "type": "tab",
        "label": "Flow 4",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "391ff15c311b00d2",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/Value/1",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 250,
        "y": 560,
        "wires": [
            [
                "6de91f63aebfaaa3",
                "91123d7b12452fe3"
            ]
        ]
    },
    {
        "id": "6de91f63aebfaaa3",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "function 18",
        "func": "msg.temp = msg.payload;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 430,
        "y": 560,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "6fde2bdece836903",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "function 19",
        "func": "msg.payload = [\n    {\n        \"timestamp\": new Date(msg.timestamp).toLocaleString(),\n        \"temperature\": msg.temp,\n        \"humidity\": msg.humi,\n\n\n    }\n];\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 770,
        "y": 600,
        "wires": [
            [
                "e3795e248eb51de9"
            ]
        ]
    },
    {
        "id": "6c5b5b120265a6eb",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/Value/2",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 250,
        "y": 640,
        "wires": [
            [
                "8383fb95606f8823",
                "a67e69eec9903f1b"
            ]
        ]
    },
    {
        "id": "8383fb95606f8823",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "function 20",
        "func": "msg.humi = msg.payload;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 430,
        "y": 640,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "e3795e248eb51de9",
        "type": "ui_table",
        "z": "eb90474bf03634f2",
        "group": "6f5566a6ee302091",
        "name": "",
        "order": 19,
        "width": 0,
        "height": 0,
        "columns": [
            {
                "field": "timestamp",
                "title": "Date",
                "width": "30%",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "temperature",
                "title": "Room1",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "humidity",
                "title": "Room2",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room3",
                "title": "Room3",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "room4",
                "title": "Room4",
                "width": "",
                "align": "left",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            }
        ],
        "outputs": 0,
        "cts": false,
        "x": 930,
        "y": 600,
        "wires": []
    },
    {
        "id": "91123d7b12452fe3",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 410,
        "y": 500,
        "wires": []
    },
    {
        "id": "a67e69eec9903f1b",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 410,
        "y": 700,
        "wires": []
    },
    {
        "id": "6dea5e38bd5f9cdf",
        "type": "join",
        "z": "eb90474bf03634f2",
        "name": "",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "2",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 610,
        "y": 600,
        "wires": [
            [
                "6fde2bdece836903"
            ]
        ]
    },
    {
        "id": "60e222c4d757a279",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 2,
        "width": 24,
        "height": 1
    },
    {
        "id": "6c89683b55b89676",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 3,
        "width": 24,
        "height": 1
    },
    {
        "id": "9030838e1ebf9689",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 7,
        "width": 4,
        "height": 1
    },
    {
        "id": "0dfe63c881942f8f",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 9,
        "width": 2,
        "height": 1
    },
    {
        "id": "d4989945c2af4f50",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 10,
        "width": 4,
        "height": 1
    },
    {
        "id": "2b2386f4e8c633b2",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 11,
        "width": 2,
        "height": 1
    },
    {
        "id": "74753ad4d37c922e",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 12,
        "width": 4,
        "height": 1
    },
    {
        "id": "231dbbfff281e746",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 13,
        "width": 2,
        "height": 1
    },
    {
        "id": "8ea5fa8b5094f2f9",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 14,
        "width": 4,
        "height": 1
    },
    {
        "id": "c5f41f7f189e5b42",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 16,
        "width": 2,
        "height": 1
    },
    {
        "id": "d5a85771e08f9bfc",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 18,
        "width": 16,
        "height": 1
    },
    {
        "id": "4e15f060b9d2a8e7",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 19,
        "width": 2,
        "height": 1
    },
    {
        "id": "1026abd9a1ed67db",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 20,
        "width": 16,
        "height": 1
    },
    {
        "id": "f9f462bf9a0f0eeb",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 21,
        "width": 2,
        "height": 1
    },
    {
        "id": "374f91fc665fa0d4",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 22,
        "width": 16,
        "height": 1
    },
    {
        "id": "dbea46012e487e49",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 23,
        "width": 2,
        "height": 1
    },
    {
        "id": "5c2a58d7d827062d",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 24,
        "width": 24,
        "height": 1
    },
    {
        "id": "da0653eb586fccca",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 25,
        "width": 22,
        "height": 1
    },
    {
        "id": "f3ef2be7e982037a",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 27,
        "width": 2,
        "height": 1
    },
    {
        "id": "b23c901aaf9f33d8",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 30,
        "width": 10,
        "height": 1
    },
    {
        "id": "63642963ec1463b5",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 31,
        "width": 2,
        "height": 1
    },
    {
        "id": "1c1ef419726482bc",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 32,
        "width": 10,
        "height": 1
    },
    {
        "id": "5a1347c3d5c51c2f",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 33,
        "width": 2,
        "height": 1
    },
    {
        "id": "48b534a52ad735cb",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 34,
        "width": 10,
        "height": 1
    },
    {
        "id": "71d0470bcfe757d9",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 35,
        "width": 2,
        "height": 1
    },
    {
        "id": "a1793790a7159696",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 36,
        "width": 12,
        "height": 1
    },
    {
        "id": "1dc04a783af09de6",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 38,
        "width": 24,
        "height": 1
    },
    {
        "id": "873e27f8eaaea457",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 39,
        "width": 24,
        "height": 1
    },
    {
        "id": "1e523d4aaa2addaf",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 40,
        "width": 24,
        "height": 1
    },
    {
        "id": "9cce3a213f266c27",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 41,
        "width": 24,
        "height": 1
    },
    {
        "id": "8f860374b003d18e",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 43,
        "width": 24,
        "height": 1
    },
    {
        "id": "bfa7be5760d9b9e5",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 44,
        "width": 24,
        "height": 1
    },
    {
        "id": "2d129f83c2d58eec",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 45,
        "width": 24,
        "height": 1
    },
    {
        "id": "fad0edd9443a7d21",
        "type": "mqtt-broker",
        "name": "",
        "broker": "91.121.93.94",
        "port": "1883",
        "clientid": "test-client",
        "autoConnect": true,
        "usetls": false,
        "protocolVersion": "4",
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "birthMsg": {},
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "closeMsg": {},
        "willTopic": "",
        "willQos": "0",
        "willPayload": "",
        "willMsg": {},
        "userProps": "",
        "sessionExpiry": ""
    },
    {
        "id": "6f5566a6ee302091",
        "type": "ui_group",
        "name": "Group 1",
        "tab": "d6eb2d1eb564a3bc",
        "order": 1,
        "disp": true,
        "width": 6
    },
    {
        "id": "d5da3e9b.46abf",
        "type": "ui_group",
        "name": "Sensor Node",
        "tab": "",
        "order": 2,
        "disp": true,
        "width": "30",
        "collapse": false,
        "className": ""
    },
    {
        "id": "d6eb2d1eb564a3bc",
        "type": "ui_tab",
        "name": "Flow4",
        "icon": "dashboard",
        "order": 18,
        "disabled": false,
        "hidden": false
    }
]

I succeeded in making two data sets visible in a table (as code uploaded), but how can I make the input data sets visible in the next row so that all input data are shown in a single table?

I managed to show all data in a row, but how to make the data always add to the new row? It is because I want to display the old and new data on the same ui table

Exactly as my example above does.

[
    {
        "id": "eb90474bf03634f2",
        "type": "tab",
        "label": "Flow 4",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "6de91f63aebfaaa3",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "Convert to global",
        "func": "global.set(\"tabletempG\", msg.payload);\n\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 450,
        "y": 560,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "6fde2bdece836903",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "function 19",
        "func": "var obtaindata0 = global.get(\"timestampG\");\nvar obtaindata1 = global.get(\"tabletempG\");\nvar obtaindata2 = global.get(\"tablehumiG\");\nvar obtaindata3 = global.get(\"tablewaterG\");\nvar obtaindata4 = global.get(\"tablerainfallG\");\nvar obtaindata5 = global.get(\"tableLEDG\");\n\n\nmsg.payload = [ \n    {\n    \"timestamp\": obtaindata0,\n    \"temperature\": obtaindata1,\n    \"humidity\": obtaindata2,\n    \"waterlevel\": obtaindata3,\n    \"rainfall\": obtaindata4,\n    \"LED\": obtaindata5,\n    }\n];\n\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 950,
        "y": 840,
        "wires": [
            [
                "db5af3dcfeacd63c",
                "2068320627081e1e"
            ]
        ]
    },
    {
        "id": "8383fb95606f8823",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "Convert to global",
        "func": "global.set(\"tablehumiG\", msg.payload);\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 450,
        "y": 640,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "e3795e248eb51de9",
        "type": "ui_table",
        "z": "eb90474bf03634f2",
        "group": "6f5566a6ee302091",
        "name": "",
        "order": 1,
        "width": 18,
        "height": 1,
        "columns": [
            {
                "field": "timestamp",
                "title": "Date & Time",
                "width": "22%",
                "align": "center",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "temperature",
                "title": "Temperature (°C)",
                "width": "17%",
                "align": "center",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "humidity",
                "title": "Relative Humidity (%)",
                "width": "20%",
                "align": "center",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "waterlevel",
                "title": "Water Level (m)",
                "width": "17%",
                "align": "center",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "rainfall",
                "title": "Rainfall (mm)",
                "width": "14%",
                "align": "center",
                "formatter": "plaintext",
                "formatterParams": {
                    "target": "_blank"
                }
            },
            {
                "field": "LED",
                "title": "Motor",
                "width": "10%",
                "align": "center",
                "formatter": "tickCross",
                "formatterParams": {
                    "target": "_blank"
                }
            }
        ],
        "outputs": 0,
        "cts": false,
        "x": 1410,
        "y": 840,
        "wires": []
    },
    {
        "id": "6dea5e38bd5f9cdf",
        "type": "join",
        "z": "eb90474bf03634f2",
        "name": "",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "4",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 730,
        "y": 700,
        "wires": [
            [
                "6fde2bdece836903"
            ]
        ]
    },
    {
        "id": "b691d6c31a21d5da",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/temperature",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 230,
        "y": 560,
        "wires": [
            [
                "6de91f63aebfaaa3"
            ]
        ]
    },
    {
        "id": "ad09411a554d6314",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/RH",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 260,
        "y": 640,
        "wires": [
            [
                "8383fb95606f8823"
            ]
        ]
    },
    {
        "id": "280340dca8fd3f70",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/rainfall",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 250,
        "y": 800,
        "wires": [
            [
                "3d0ac081d960d2ca",
                "2bb5565794518d2a"
            ]
        ]
    },
    {
        "id": "98dc55f8397d8abc",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "",
        "topic": "room/waterLevel",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 240,
        "y": 720,
        "wires": [
            [
                "1215a45fb0e5b173"
            ]
        ]
    },
    {
        "id": "434fd8dea6e37959",
        "type": "mqtt in",
        "z": "eb90474bf03634f2",
        "name": "LED Status",
        "topic": "room/ledstatus",
        "qos": "2",
        "datatype": "auto-detect",
        "broker": "fad0edd9443a7d21",
        "nl": false,
        "rap": true,
        "rh": 0,
        "inputs": 0,
        "x": 250,
        "y": 920,
        "wires": [
            [
                "fe079a0ed62fac27"
            ]
        ]
    },
    {
        "id": "3d0ac081d960d2ca",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "Convert to global",
        "func": "global.set(\"tablerainfallG\", msg.payload);\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 450,
        "y": 800,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "1215a45fb0e5b173",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "Convert to global",
        "func": "global.set(\"tablewaterG\", msg.payload);\n\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 450,
        "y": 720,
        "wires": [
            [
                "6dea5e38bd5f9cdf"
            ]
        ]
    },
    {
        "id": "f8bc32727f124d18",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "Convert to global",
        "func": "global.set(\"tableLEDG\", msg.payload);\n\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 650,
        "y": 920,
        "wires": [
            [
                "6fde2bdece836903",
                "d9eb80bdd775fdf7"
            ]
        ]
    },
    {
        "id": "db5af3dcfeacd63c",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 1250,
        "y": 660,
        "wires": []
    },
    {
        "id": "4e746eb2a211b137",
        "type": "function",
        "z": "eb90474bf03634f2",
        "name": "function 22",
        "func": "var timestamp = msg.payload;\nvar time = new Date(timestamp).toLocaleString();\nglobal.set(\"timestampG\", time);\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 690,
        "y": 820,
        "wires": [
            [
                "6fde2bdece836903"
            ]
        ]
    },
    {
        "id": "2bb5565794518d2a",
        "type": "change",
        "z": "eb90474bf03634f2",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "",
                "tot": "date"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 460,
        "y": 860,
        "wires": [
            [
                "4e746eb2a211b137"
            ]
        ]
    },
    {
        "id": "2068320627081e1e",
        "type": "change",
        "z": "eb90474bf03634f2",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload.command",
                "pt": "msg",
                "to": "addRow",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 1200,
        "y": 840,
        "wires": [
            [
                "e3795e248eb51de9"
            ]
        ]
    },
    {
        "id": "fe079a0ed62fac27",
        "type": "change",
        "z": "eb90474bf03634f2",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "true",
                "tot": "bool"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 480,
        "y": 980,
        "wires": [
            [
                "f8bc32727f124d18",
                "0df4b8c167ebe8d2"
            ]
        ]
    },
    {
        "id": "0df4b8c167ebe8d2",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 650,
        "y": 1020,
        "wires": []
    },
    {
        "id": "d9eb80bdd775fdf7",
        "type": "debug",
        "z": "eb90474bf03634f2",
        "name": "debug",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "payload",
        "targetType": "msg",
        "statusVal": "",
        "statusType": "auto",
        "x": 830,
        "y": 960,
        "wires": []
    },
    {
        "id": "60e222c4d757a279",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 2,
        "width": 24,
        "height": 1
    },
    {
        "id": "6c89683b55b89676",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 3,
        "width": 24,
        "height": 1
    },
    {
        "id": "9030838e1ebf9689",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 7,
        "width": 4,
        "height": 1
    },
    {
        "id": "0dfe63c881942f8f",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 9,
        "width": 2,
        "height": 1
    },
    {
        "id": "d4989945c2af4f50",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 10,
        "width": 4,
        "height": 1
    },
    {
        "id": "2b2386f4e8c633b2",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 11,
        "width": 2,
        "height": 1
    },
    {
        "id": "74753ad4d37c922e",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 12,
        "width": 4,
        "height": 1
    },
    {
        "id": "231dbbfff281e746",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 13,
        "width": 2,
        "height": 1
    },
    {
        "id": "8ea5fa8b5094f2f9",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 14,
        "width": 4,
        "height": 1
    },
    {
        "id": "c5f41f7f189e5b42",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 16,
        "width": 2,
        "height": 1
    },
    {
        "id": "d5a85771e08f9bfc",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 18,
        "width": 16,
        "height": 1
    },
    {
        "id": "4e15f060b9d2a8e7",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 19,
        "width": 2,
        "height": 1
    },
    {
        "id": "1026abd9a1ed67db",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 20,
        "width": 16,
        "height": 1
    },
    {
        "id": "f9f462bf9a0f0eeb",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 21,
        "width": 2,
        "height": 1
    },
    {
        "id": "374f91fc665fa0d4",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 22,
        "width": 16,
        "height": 1
    },
    {
        "id": "dbea46012e487e49",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 23,
        "width": 2,
        "height": 1
    },
    {
        "id": "5c2a58d7d827062d",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 24,
        "width": 24,
        "height": 1
    },
    {
        "id": "da0653eb586fccca",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 25,
        "width": 22,
        "height": 1
    },
    {
        "id": "f3ef2be7e982037a",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 27,
        "width": 2,
        "height": 1
    },
    {
        "id": "b23c901aaf9f33d8",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 30,
        "width": 10,
        "height": 1
    },
    {
        "id": "63642963ec1463b5",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 31,
        "width": 2,
        "height": 1
    },
    {
        "id": "1c1ef419726482bc",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 32,
        "width": 10,
        "height": 1
    },
    {
        "id": "5a1347c3d5c51c2f",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 33,
        "width": 2,
        "height": 1
    },
    {
        "id": "48b534a52ad735cb",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 34,
        "width": 10,
        "height": 1
    },
    {
        "id": "71d0470bcfe757d9",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 35,
        "width": 2,
        "height": 1
    },
    {
        "id": "a1793790a7159696",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 36,
        "width": 12,
        "height": 1
    },
    {
        "id": "1dc04a783af09de6",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 38,
        "width": 24,
        "height": 1
    },
    {
        "id": "873e27f8eaaea457",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 39,
        "width": 24,
        "height": 1
    },
    {
        "id": "1e523d4aaa2addaf",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 40,
        "width": 24,
        "height": 1
    },
    {
        "id": "9cce3a213f266c27",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 41,
        "width": 24,
        "height": 1
    },
    {
        "id": "8f860374b003d18e",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 43,
        "width": 24,
        "height": 1
    },
    {
        "id": "bfa7be5760d9b9e5",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 44,
        "width": 24,
        "height": 1
    },
    {
        "id": "2d129f83c2d58eec",
        "type": "ui_spacer",
        "z": "eb90474bf03634f2",
        "name": "spacer",
        "group": "d5da3e9b.46abf",
        "order": 45,
        "width": 24,
        "height": 1
    },
    {
        "id": "6f5566a6ee302091",
        "type": "ui_group",
        "name": "Group 1",
        "tab": "d6eb2d1eb564a3bc",
        "order": 1,
        "disp": true,
        "width": 18
    },
    {
        "id": "fad0edd9443a7d21",
        "type": "mqtt-broker",
        "name": "",
        "broker": "91.121.93.94",
        "port": "1883",
        "clientid": "test-client",
        "autoConnect": true,
        "usetls": false,
        "protocolVersion": "4",
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "birthMsg": {},
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "closeMsg": {},
        "willTopic": "",
        "willQos": "0",
        "willPayload": "",
        "willMsg": {},
        "userProps": "",
        "sessionExpiry": ""
    },
    {
        "id": "d5da3e9b.46abf",
        "type": "ui_group",
        "name": "Sensor Node",
        "tab": "",
        "order": 2,
        "disp": true,
        "width": "30",
        "collapse": false,
        "className": ""
    },
    {
        "id": "d6eb2d1eb564a3bc",
        "type": "ui_tab",
        "name": "Flow4",
        "icon": "dashboard",
        "order": 18,
        "disabled": false,
        "hidden": false
    }
]

This is the flow I did. I tried to combine the example you gave to me, but it is unsuccessful. Can you guide me on it?
Thanks

Your flow has 35 ui-nodes that if i load i would have to delete manually.

Here is another way to add the data to the table by storing the data table in flow context, so you can append new data to it. I have limited it to 200 entries, editable in the change node JSONata expression. In this example I append data to top of table.

[{"id":"2bb5565794518d2a","type":"change","z":"eb90474bf03634f2","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"$split($$.topic, \"/\")[-1]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":250.00000762939453,"y":836.2500371932983,"wires":[["6dea5e38bd5f9cdf"]]},{"id":"280340dca8fd3f70","type":"mqtt in","z":"eb90474bf03634f2","name":"","topic":"room/+","qos":"2","datatype":"auto-detect","broker":"e8ba3ef5.22f4a8","nl":false,"rap":true,"rh":0,"inputs":0,"x":100.00000762939453,"y":836.2500371932983,"wires":[["2bb5565794518d2a"]]},{"id":"6dea5e38bd5f9cdf","type":"join","z":"eb90474bf03634f2","name":"join","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"5","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":400.00000762939453,"y":836.2500371932983,"wires":[["5905fbdbfb3a4952"]]},{"id":"5905fbdbfb3a4952","type":"change","z":"eb90474bf03634f2","name":"","rules":[{"t":"set","p":"payload.timestamp","pt":"msg","to":"$moment().tz(\"Europe/London\").format(\"YYYY/MM/DD HH:mm:ss\")","tot":"jsonata"},{"t":"set","p":"table_data","pt":"flow","to":"$append([$$.payload],$flowContext(\"table_data\")[])[[0..200]]","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"table_data","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":600,"y":840,"wires":[["e3795e248eb51de9","db5af3dcfeacd63c"]]},{"id":"e3795e248eb51de9","type":"ui_table","z":"eb90474bf03634f2","group":"6f5566a6ee302091","name":"","order":1,"width":18,"height":1,"columns":[{"field":"timestamp","title":"Date & Time","width":"22%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"temperature","title":"Temperature (°C)","width":"17%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"RH","title":"Relative Humidity (%)","width":"20%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"waterLevel","title":"Water Level (m)","width":"17%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"rainfall","title":"Rainfall (mm)","width":"14%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"ledstatus","title":"Motor","width":"10%","align":"center","formatter":"tickCross","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":830,"y":840,"wires":[]},{"id":"db5af3dcfeacd63c","type":"debug","z":"eb90474bf03634f2","name":"debug","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload.arguments[0][0].ledstatus","statusType":"msg","x":620.0000076293945,"y":716.2500371932983,"wires":[]},{"id":"d95b84f983b78c88","type":"inject","z":"eb90474bf03634f2","name":"led status","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/ledstatus","payload":"$round($random())","payloadType":"jsonata","x":240,"y":660,"wires":[["ee4307e0690cc39e"]]},{"id":"d170c19bc6af3f3c","type":"inject","z":"eb90474bf03634f2","name":"rainfall","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/rainfall","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":620,"wires":[["ee4307e0690cc39e"]]},{"id":"a878762a751c1f0b","type":"inject","z":"eb90474bf03634f2","name":"waterlevel","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/waterLevel","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":240,"y":580,"wires":[["ee4307e0690cc39e"]]},{"id":"fed906875fb9dc94","type":"inject","z":"eb90474bf03634f2","name":"rh","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/RH","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":540,"wires":[["ee4307e0690cc39e"]]},{"id":"c8d93b4324f72787","type":"inject","z":"eb90474bf03634f2","name":"temp","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/temperature","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":500,"wires":[["ee4307e0690cc39e"]]},{"id":"ee4307e0690cc39e","type":"mqtt out","z":"eb90474bf03634f2","name":"send test data","topic":"","qos":"","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"e8ba3ef5.22f4a8","x":460,"y":520,"wires":[]},{"id":"e8ba3ef5.22f4a8","type":"mqtt-broker","name":"testb","broker":"192.168.1.25","port":"1883","clientid":"node-red-test","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"userProps":"","sessionExpiry":""},{"id":"6f5566a6ee302091","type":"ui_group","name":"Group 1","tab":"d6eb2d1eb564a3bc","order":1,"disp":true,"width":18},{"id":"d6eb2d1eb564a3bc","type":"ui_tab","name":"Flow4","icon":"dashboard","order":18,"disabled":false,"hidden":false}]

I really don't understand why you are storing data to globals when available in flow message.

Thanks for your help.
Actually, my first attempt is using the wildcard type, but no data are shown in the table. Then, I tried to separate all the data and join them together, and it works.
I stored the data in global as for future expansion, so that I would not need to duplicate the same node on the same tab.

Thanks for your code, it works. However, I have an issue on displaying the data. Since the 5 input data will be sent at the same time, why the table not showing all data? Some data are shown but some are not. May I know what is the possible issue that causes this situation happens?

From the picture, I realised some consequent rows have a short time interval. The data I sent through mqtt is 8 seconds tie interval.

Let me get my crystal ball. Or you could supply the data i need to answer that question

At a guess my uitable is configured different to yours, check the property names. Or the data was not received when the join finished.

As to globals the whole table is stored so no need for global of individual values, and context can also lead to race conditions, if not craeful

May I know is there any way to solve this issue?

I think you can try to connect to my broker to get the supply data

Its not the lack of data, you show me an image, tell me there is an issue, but i have no way of knowing how you have configured things. I have given two very good examples but you seem to have ignored their layout, as my testing with my examples leaves no gaps.