# Spliting payload
**URL:** https://discourse.nodered.org/t/spliting-payload/80181
**Category:** General
**Created:** [31 July 2023 09:50 UTC](https://discourse.nodered.org/t/spliting-payload/80181 "2023-07-31T09:50:57Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 09:50 UTC](https://discourse.nodered.org/t/spliting-payload/80181/1 "2023-07-31T09:50:57Z")
Hello,
We have this msg.payload and we need to get the value of avg(IN01)
When we use .split code, we get the error that's not a function.
Can you advice us or give a example on how to work ?
Thanks,
31/07/2023, 11:45:39[node: debug 3](http://10.180.50.25:1880/#)SELECT avg(IN01) FROM COMPTEUR\_GENERAL; : msg.payload : array[1]
array[1]
0: object
avg(IN01): 77.7317
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [31 July 2023 09:57 UTC](https://discourse.nodered.org/t/spliting-payload/80181/2 "2023-07-31T09:57:20Z")
Your payload is an array of 1 object not a string, .split is a function of a string value.
`msg.payload[0]["avg(IN01)"]` should hold the value 77.7317
To give the payload property a better name change you sql query to
`SELECT avg(IN01) AS average_value FROM COMPTEUR_GENERAL;`
then the value would be `msg.payload[0].average_value`
---
### Author:  [@meeki007](https://discourse.nodered.org/u/meeki007)
#### Post date: [31 July 2023 09:59 UTC](https://discourse.nodered.org/t/spliting-payload/80181/3 "2023-07-31T09:59:54Z")
Can you share your msg object with us please.
When you paste it here please use formatting for the code.
[https://discourse.nodered.org/t/how-to-post-code-or-flows/69516](https://discourse.nodered.org/t/how-to-post-code-or-flows/69516)
Also a sharing (export) of your current flow will help as well.
---
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 10:16 UTC](https://discourse.nodered.org/t/spliting-payload/80181/4 "2023-07-31T10:16:51Z")
Thanks for your rapid answer.
With msg.payload[0]["avg(IN01)"], I Have the same output
array[1]
0: object
avg(IN01): 77.7317
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [31 July 2023 10:22 UTC](https://discourse.nodered.org/t/spliting-payload/80181/5 "2023-07-31T10:22:56Z")
Try this example
```auto
[{"id":"3e9e25c4f6c0d19e","type":"inject","z":"b9860b4b9de8c8da","name":"","props":[{"p":"msg.payload[0][\"avg(IN01)\"]","v":"77.7317","vt":"num"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"SELECT avg(IN01) FROM COMPTEUR_GENERAL;","x":230,"y":80,"wires":[["cf43de2fe6b665d1","7082854e73fb5f27"]]},{"id":"cf43de2fe6b665d1","type":"debug","z":"b9860b4b9de8c8da","name":"debug 324","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":310,"y":140,"wires":[]},{"id":"7082854e73fb5f27","type":"change","z":"b9860b4b9de8c8da","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"msg.payload[0][\"avg(IN01)\"]","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":420,"y":80,"wires":[["a96c0f091f51f463"]]},{"id":"a96c0f091f51f463","type":"debug","z":"b9860b4b9de8c8da","name":"debug 325","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":550,"y":120,"wires":[]}]
```
[How to import a flow](https://nodered.org/docs/user-guide/editor/workspace/import-export)
These links may help
[working with messages](https://nodered.org/docs/user-guide/messages)
[essentials videos](https://m.youtube.com/watch?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6&v=ksGeUD26Mw0&embeds_referring_euri=https%3A%2F%2Fnodered.org%2F&source_ve_path=OTY3MTQ&feature=emb_imp_woyt)
---
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 10:43 UTC](https://discourse.nodered.org/t/spliting-payload/80181/6 "2023-07-31T10:43:04Z")
You make my day; It's ok.
I need to learn more !
Thanks a lot,
marc,
---
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 12:48 UTC](https://discourse.nodered.org/t/spliting-payload/80181/7 "2023-07-31T12:48:50Z")
If I can ask a help.
I need also display number of records in DB.
I have this as output but how to get only 126 ?
Thanks,
SELECT COUNT(IN01) FROM COMPTEUR\_GENERAL; : msg.payload : array[1]
array[1]
0: object
COUNT(IN01): 126
---
### Author:  [@jbudd](https://discourse.nodered.org/u/jbudd)
#### Post date: [31 July 2023 13:22 UTC](https://discourse.nodered.org/t/spliting-payload/80181/8 "2023-07-31T13:22:00Z")
You will make life simpler for yourself if you follow @E1cid's advice and change your SQL to use only alphabetic characters in the returned field names.
For example
`SELECT COUNT(IN01) AS records FROM COMPTEUR_GENERAL`
Then the value you want will be in msg.payload[0].records
---
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 13:35 UTC](https://discourse.nodered.org/t/spliting-payload/80181/9 "2023-07-31T13:35:00Z")
I tried but I get "undefined" messahe as output
---
### Author:  [@jbudd](https://discourse.nodered.org/u/jbudd)
#### Post date: [31 July 2023 13:39 UTC](https://discourse.nodered.org/t/spliting-payload/80181/10 "2023-07-31T13:39:59Z")
What database are you using? eg Mariadb, MSSQL, ...
Can you show us the output from the database node?
---
### Author:  [@ACD2040](https://discourse.nodered.org/u/ACD2040)
#### Post date: [31 July 2023 13:44 UTC](https://discourse.nodered.org/t/spliting-payload/80181/11 "2023-07-31T13:44:27Z")
Maria Db on SYnology. Its' ok I found my error.
Thanks,
marc,
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [29 September 2023 13:44 UTC](https://discourse.nodered.org/t/spliting-payload/80181/12 "2023-09-29T13:44:52Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.